--
-- Kingbase database dump
--

-- Dumped from database version 12.1
-- Dumped by sys_dump version 12.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', 'public', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_with_oids = off;
SET default_with_rowid = off;
SET comp_v7_program_para_def = on;

--
-- Name: ry_vue; Type: SCHEMA; Schema: -; Owner: system
--

CREATE SCHEMA ry_vue;


ALTER SCHEMA ry_vue OWNER TO system;

--
-- Name: FIND_IN_SET(varchar, varchar, varchar); Type: FUNCTION; Schema: ry_vue; Owner: system
--

\set SQLTERM /
CREATE FUNCTION ry_vue."FIND_IN_SET"(piv_str1 varchar, piv_str2 varchar, p_sep varchar DEFAULT ','::varchar) RETURNS integer
    LANGUAGE plpgsql
    AS $KES_$ DECLARE
l_idx NUMBER := 0;
	tmp
text[];
BEGIN

SELECT regexp_split_to_array(piv_str2, p_sep)
INTO tmp;

FOR i IN 0..array_length(tmp, 1) LOOP
		IF piv_str1 = tmp[i] THEN
			l_idx = i
			EXIT;
END IF;
END LOOP;

RETURN l_idx;

END ;$KES_$;

/
\set SQLTERM ;


ALTER FUNCTION ry_vue."FIND_IN_SET"(piv_str1 varchar, piv_str2 varchar, p_sep varchar) OWNER TO system;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: QRTZ_BLOB_TRIGGERS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_BLOB_TRIGGERS" (
    sched_name character varying(120 char) NOT NULL,
    trigger_name character varying(200 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL,
    blob_data blob
);


ALTER TABLE ry_vue."QRTZ_BLOB_TRIGGERS" OWNER TO system;

--
-- Name: TABLE "QRTZ_BLOB_TRIGGERS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_BLOB_TRIGGERS" IS 'Blob类型的触发器表';


--
-- Name: COLUMN "QRTZ_BLOB_TRIGGERS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_BLOB_TRIGGERS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_BLOB_TRIGGERS".trigger_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_BLOB_TRIGGERS".trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- Name: COLUMN "QRTZ_BLOB_TRIGGERS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_BLOB_TRIGGERS".trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- Name: COLUMN "QRTZ_BLOB_TRIGGERS".blob_data; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_BLOB_TRIGGERS".blob_data IS '存放持久化Trigger对象';


--
-- Name: QRTZ_CALENDARS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_CALENDARS" (
    sched_name character varying(120 char) NOT NULL,
    calendar_name character varying(200 char) NOT NULL,
    calendar blob NOT NULL
);


ALTER TABLE ry_vue."QRTZ_CALENDARS" OWNER TO system;

--
-- Name: TABLE "QRTZ_CALENDARS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_CALENDARS" IS '日历信息表';


--
-- Name: COLUMN "QRTZ_CALENDARS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CALENDARS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_CALENDARS".calendar_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CALENDARS".calendar_name IS '日历名称';


--
-- Name: COLUMN "QRTZ_CALENDARS".calendar; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CALENDARS".calendar IS '存放持久化calendar对象';


--
-- Name: QRTZ_CRON_TRIGGERS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_CRON_TRIGGERS" (
    sched_name character varying(120 char) NOT NULL,
    trigger_name character varying(200 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL,
    cron_expression character varying(200 char) NOT NULL,
    time_zone_id character varying(80 char)
);


ALTER TABLE ry_vue."QRTZ_CRON_TRIGGERS" OWNER TO system;

--
-- Name: TABLE "QRTZ_CRON_TRIGGERS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_CRON_TRIGGERS" IS 'Cron类型的触发器表';


--
-- Name: COLUMN "QRTZ_CRON_TRIGGERS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CRON_TRIGGERS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_CRON_TRIGGERS".trigger_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CRON_TRIGGERS".trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- Name: COLUMN "QRTZ_CRON_TRIGGERS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CRON_TRIGGERS".trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- Name: COLUMN "QRTZ_CRON_TRIGGERS".cron_expression; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CRON_TRIGGERS".cron_expression IS 'cron表达式';


--
-- Name: COLUMN "QRTZ_CRON_TRIGGERS".time_zone_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_CRON_TRIGGERS".time_zone_id IS '时区';


--
-- Name: QRTZ_FIRED_TRIGGERS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_FIRED_TRIGGERS" (
    sched_name character varying(120 char) NOT NULL,
    entry_id character varying(95 char) NOT NULL,
    trigger_name character varying(200 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL,
    instance_name character varying(200 char) NOT NULL,
    fired_time bigint NOT NULL,
    sched_time bigint NOT NULL,
    priority integer NOT NULL,
    state character varying(16 char) NOT NULL,
    job_name character varying(200 char),
    job_group character varying(200 char),
    is_nonconcurrent character varying(1 char),
    requests_recovery character varying(1 char)
);


ALTER TABLE ry_vue."QRTZ_FIRED_TRIGGERS" OWNER TO system;

--
-- Name: TABLE "QRTZ_FIRED_TRIGGERS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_FIRED_TRIGGERS" IS '已触发的触发器表';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".entry_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".entry_id IS '调度器实例id';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".trigger_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".instance_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".instance_name IS '调度器实例名';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".fired_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".fired_time IS '触发的时间';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".sched_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".sched_time IS '定时器制定的时间';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".priority; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".priority IS '优先级';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".state; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".state IS '状态';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".job_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".job_name IS '任务名称';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".job_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".job_group IS '任务组名';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".is_nonconcurrent; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".is_nonconcurrent IS '是否并发';


--
-- Name: COLUMN "QRTZ_FIRED_TRIGGERS".requests_recovery; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_FIRED_TRIGGERS".requests_recovery IS '是否接受恢复执行';


--
-- Name: QRTZ_JOB_DETAILS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_JOB_DETAILS" (
    sched_name character varying(120 char) NOT NULL,
    job_name character varying(200 char) NOT NULL,
    job_group character varying(200 char) NOT NULL,
    description character varying(250 char),
    job_class_name character varying(250 char) NOT NULL,
    is_durable character varying(1 char) NOT NULL,
    is_nonconcurrent character varying(1 char) NOT NULL,
    is_update_data character varying(1 char) NOT NULL,
    requests_recovery character varying(1 char) NOT NULL,
    job_data blob
);


ALTER TABLE ry_vue."QRTZ_JOB_DETAILS" OWNER TO system;

--
-- Name: TABLE "QRTZ_JOB_DETAILS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_JOB_DETAILS" IS '任务详细信息表';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".job_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".job_name IS '任务名称';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".job_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".job_group IS '任务组名';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".description; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".description IS '相关介绍';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".job_class_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".job_class_name IS '执行任务类名称';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".is_durable; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".is_durable IS '是否持久化';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".is_nonconcurrent; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".is_nonconcurrent IS '是否并发';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".is_update_data; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".is_update_data IS '是否更新数据';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".requests_recovery; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".requests_recovery IS '是否接受恢复执行';


--
-- Name: COLUMN "QRTZ_JOB_DETAILS".job_data; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_JOB_DETAILS".job_data IS '存放持久化job对象';


--
-- Name: QRTZ_LOCKS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_LOCKS" (
    sched_name character varying(120 char) NOT NULL,
    lock_name character varying(40 char) NOT NULL
);


ALTER TABLE ry_vue."QRTZ_LOCKS" OWNER TO system;

--
-- Name: TABLE "QRTZ_LOCKS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_LOCKS" IS '存储的悲观锁信息表';


--
-- Name: COLUMN "QRTZ_LOCKS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_LOCKS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_LOCKS".lock_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_LOCKS".lock_name IS '悲观锁名称';


--
-- Name: QRTZ_PAUSED_TRIGGER_GRPS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_PAUSED_TRIGGER_GRPS" (
    sched_name character varying(120 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL
);


ALTER TABLE ry_vue."QRTZ_PAUSED_TRIGGER_GRPS" OWNER TO system;

--
-- Name: TABLE "QRTZ_PAUSED_TRIGGER_GRPS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_PAUSED_TRIGGER_GRPS" IS '暂停的触发器表';


--
-- Name: COLUMN "QRTZ_PAUSED_TRIGGER_GRPS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_PAUSED_TRIGGER_GRPS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_PAUSED_TRIGGER_GRPS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_PAUSED_TRIGGER_GRPS".trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- Name: QRTZ_SCHEDULER_STATE; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_SCHEDULER_STATE" (
    sched_name character varying(120 char) NOT NULL,
    instance_name character varying(200 char) NOT NULL,
    last_checkin_time bigint NOT NULL,
    checkin_interval bigint NOT NULL
);


ALTER TABLE ry_vue."QRTZ_SCHEDULER_STATE" OWNER TO system;

--
-- Name: TABLE "QRTZ_SCHEDULER_STATE"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_SCHEDULER_STATE" IS '调度器状态表';


--
-- Name: COLUMN "QRTZ_SCHEDULER_STATE".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SCHEDULER_STATE".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_SCHEDULER_STATE".instance_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SCHEDULER_STATE".instance_name IS '实例名称';


--
-- Name: COLUMN "QRTZ_SCHEDULER_STATE".last_checkin_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SCHEDULER_STATE".last_checkin_time IS '上次检查时间';


--
-- Name: COLUMN "QRTZ_SCHEDULER_STATE".checkin_interval; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SCHEDULER_STATE".checkin_interval IS '检查间隔时间';


--
-- Name: QRTZ_SIMPLE_TRIGGERS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_SIMPLE_TRIGGERS" (
    sched_name character varying(120 char) NOT NULL,
    trigger_name character varying(200 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL,
    repeat_count bigint NOT NULL,
    repeat_interval bigint NOT NULL,
    times_triggered bigint NOT NULL
);


ALTER TABLE ry_vue."QRTZ_SIMPLE_TRIGGERS" OWNER TO system;

--
-- Name: TABLE "QRTZ_SIMPLE_TRIGGERS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_SIMPLE_TRIGGERS" IS '简单触发器的信息表';


--
-- Name: COLUMN "QRTZ_SIMPLE_TRIGGERS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPLE_TRIGGERS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_SIMPLE_TRIGGERS".trigger_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPLE_TRIGGERS".trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- Name: COLUMN "QRTZ_SIMPLE_TRIGGERS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPLE_TRIGGERS".trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- Name: COLUMN "QRTZ_SIMPLE_TRIGGERS".repeat_count; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPLE_TRIGGERS".repeat_count IS '重复的次数统计';


--
-- Name: COLUMN "QRTZ_SIMPLE_TRIGGERS".repeat_interval; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPLE_TRIGGERS".repeat_interval IS '重复的间隔时间';


--
-- Name: COLUMN "QRTZ_SIMPLE_TRIGGERS".times_triggered; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPLE_TRIGGERS".times_triggered IS '已经触发的次数';


--
-- Name: QRTZ_SIMPROP_TRIGGERS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_SIMPROP_TRIGGERS" (
    sched_name character varying(120 char) NOT NULL,
    trigger_name character varying(200 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL,
    str_prop_1 character varying(512 char),
    str_prop_2 character varying(512 char),
    str_prop_3 character varying(512 char),
    int_prop_1 integer,
    int_prop_2 integer,
    long_prop_1 bigint,
    long_prop_2 bigint,
    dec_prop_1 numeric(13,4),
    dec_prop_2 numeric(13,4),
    bool_prop_1 character varying(1 char),
    bool_prop_2 character varying(1 char)
);


ALTER TABLE ry_vue."QRTZ_SIMPROP_TRIGGERS" OWNER TO system;

--
-- Name: TABLE "QRTZ_SIMPROP_TRIGGERS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_SIMPROP_TRIGGERS" IS '同步机制的行锁表';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".trigger_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".str_prop_1; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".str_prop_1 IS 'String类型的trigger的第一个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".str_prop_2; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".str_prop_2 IS 'String类型的trigger的第二个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".str_prop_3; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".str_prop_3 IS 'String类型的trigger的第三个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".int_prop_1; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".int_prop_1 IS 'int类型的trigger的第一个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".int_prop_2; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".int_prop_2 IS 'int类型的trigger的第二个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".long_prop_1; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".long_prop_1 IS 'long类型的trigger的第一个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".long_prop_2; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".long_prop_2 IS 'long类型的trigger的第二个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".dec_prop_1; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".dec_prop_1 IS 'decimal类型的trigger的第一个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".dec_prop_2; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".dec_prop_2 IS 'decimal类型的trigger的第二个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".bool_prop_1; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".bool_prop_1 IS 'Boolean类型的trigger的第一个参数';


--
-- Name: COLUMN "QRTZ_SIMPROP_TRIGGERS".bool_prop_2; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_SIMPROP_TRIGGERS".bool_prop_2 IS 'Boolean类型的trigger的第二个参数';


--
-- Name: QRTZ_TRIGGERS; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue."QRTZ_TRIGGERS" (
    sched_name character varying(120 char) NOT NULL,
    trigger_name character varying(200 char) NOT NULL,
    trigger_group character varying(200 char) NOT NULL,
    job_name character varying(200 char) NOT NULL,
    job_group character varying(200 char) NOT NULL,
    description character varying(250 char),
    next_fire_time bigint,
    prev_fire_time bigint,
    priority integer,
    trigger_state character varying(16 char) NOT NULL,
    trigger_type character varying(8 char) NOT NULL,
    start_time bigint NOT NULL,
    end_time bigint,
    calendar_name character varying(200 char),
    misfire_instr smallint,
    job_data blob
);


ALTER TABLE ry_vue."QRTZ_TRIGGERS" OWNER TO system;

--
-- Name: TABLE "QRTZ_TRIGGERS"; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue."QRTZ_TRIGGERS" IS '触发器详细信息表';


--
-- Name: COLUMN "QRTZ_TRIGGERS".sched_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".sched_name IS '调度名称';


--
-- Name: COLUMN "QRTZ_TRIGGERS".trigger_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".trigger_name IS '触发器的名字';


--
-- Name: COLUMN "QRTZ_TRIGGERS".trigger_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".trigger_group IS '触发器所属组的名字';


--
-- Name: COLUMN "QRTZ_TRIGGERS".job_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".job_name IS 'qrtz_job_details表job_name的外键';


--
-- Name: COLUMN "QRTZ_TRIGGERS".job_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".job_group IS 'qrtz_job_details表job_group的外键';


--
-- Name: COLUMN "QRTZ_TRIGGERS".description; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".description IS '相关介绍';


--
-- Name: COLUMN "QRTZ_TRIGGERS".next_fire_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".next_fire_time IS '上一次触发时间（毫秒）';


--
-- Name: COLUMN "QRTZ_TRIGGERS".prev_fire_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".prev_fire_time IS '下一次触发时间（默认为-1表示不触发）';


--
-- Name: COLUMN "QRTZ_TRIGGERS".priority; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".priority IS '优先级';


--
-- Name: COLUMN "QRTZ_TRIGGERS".trigger_state; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".trigger_state IS '触发器状态';


--
-- Name: COLUMN "QRTZ_TRIGGERS".trigger_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".trigger_type IS '触发器的类型';


--
-- Name: COLUMN "QRTZ_TRIGGERS".start_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".start_time IS '开始时间';


--
-- Name: COLUMN "QRTZ_TRIGGERS".end_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".end_time IS '结束时间';


--
-- Name: COLUMN "QRTZ_TRIGGERS".calendar_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".calendar_name IS '日程表名称';


--
-- Name: COLUMN "QRTZ_TRIGGERS".misfire_instr; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".misfire_instr IS '补偿执行的策略';


--
-- Name: COLUMN "QRTZ_TRIGGERS".job_data; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue."QRTZ_TRIGGERS".job_data IS '存放持久化job对象';


--
-- Name: gen_table; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.gen_table (
    table_id bigint NOT NULL,
    table_name character varying(200 char) DEFAULT NULL::varchar,
    table_comment character varying(500 char) DEFAULT NULL::varchar,
    sub_table_name character varying(64 char),
    sub_table_fk_name character varying(64 char),
    class_name character varying(100 char) DEFAULT NULL::varchar,
    tpl_category character varying(200 char) DEFAULT 'crud'::varchar,
    package_name character varying(100 char),
    module_name character varying(30 char),
    business_name character varying(30 char),
    function_name character varying(50 char),
    function_author character varying(50 char),
    gen_type character(1 char) DEFAULT '0'::bpchar,
    gen_path character varying(200 char) DEFAULT '/'::varchar,
    options character varying(1000 char),
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char),
    tpl_web_type character varying(300 char)
);


ALTER TABLE ry_vue.gen_table OWNER TO system;

--
-- Name: TABLE gen_table; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.gen_table IS '代码生成业务表';


--
-- Name: COLUMN gen_table.table_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.table_id IS '编号';


--
-- Name: COLUMN gen_table.table_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.table_name IS '表名称';


--
-- Name: COLUMN gen_table.table_comment; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.table_comment IS '表描述';


--
-- Name: COLUMN gen_table.sub_table_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.sub_table_name IS '关联子表的表名';


--
-- Name: COLUMN gen_table.sub_table_fk_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.sub_table_fk_name IS '子表关联的外键名';


--
-- Name: COLUMN gen_table.class_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.class_name IS '实体类名称';


--
-- Name: COLUMN gen_table.tpl_category; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.tpl_category IS '使用的模板（crud单表操作 tree树表操作）';


--
-- Name: COLUMN gen_table.package_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.package_name IS '生成包路径';


--
-- Name: COLUMN gen_table.module_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.module_name IS '生成模块名';


--
-- Name: COLUMN gen_table.business_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.business_name IS '生成业务名';


--
-- Name: COLUMN gen_table.function_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.function_name IS '生成功能名';


--
-- Name: COLUMN gen_table.function_author; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.function_author IS '生成功能作者';


--
-- Name: COLUMN gen_table.gen_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.gen_type IS '生成代码方式（0zip压缩包 1自定义路径）';


--
-- Name: COLUMN gen_table.gen_path; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.gen_path IS '生成路径（不填默认项目路径）';


--
-- Name: COLUMN gen_table.options; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.options IS '其它生成选项';


--
-- Name: COLUMN gen_table.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.create_by IS '创建者';


--
-- Name: COLUMN gen_table.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.create_time IS '创建时间';


--
-- Name: COLUMN gen_table.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.update_by IS '更新者';


--
-- Name: COLUMN gen_table.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.update_time IS '更新时间';


--
-- Name: COLUMN gen_table.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table.remark IS '备注';


--
-- Name: gen_table_column; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.gen_table_column (
    column_id bigint NOT NULL,
    table_id character varying(64 char),
    column_name character varying(200 char),
    column_comment character varying(500 char),
    column_type character varying(100 char),
    java_type character varying(500 char),
    java_field character varying(200 char),
    is_pk character(1 char),
    is_increment character(1 char),
    is_required character(1 char),
    is_insert character(1 char),
    is_edit character(1 char),
    is_list character(1 char),
    is_query character(1 char),
    query_type character varying(200 char) DEFAULT 'EQ'::varchar,
    html_type character varying(200 char),
    dict_type character varying(200 char) DEFAULT NULL::varchar,
    sort integer,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone
);


ALTER TABLE ry_vue.gen_table_column OWNER TO system;

--
-- Name: TABLE gen_table_column; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.gen_table_column IS '代码生成业务表字段';


--
-- Name: COLUMN gen_table_column.column_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.column_id IS '编号';


--
-- Name: COLUMN gen_table_column.table_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.table_id IS '归属表编号';


--
-- Name: COLUMN gen_table_column.column_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.column_name IS '列名称';


--
-- Name: COLUMN gen_table_column.column_comment; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.column_comment IS '列描述';


--
-- Name: COLUMN gen_table_column.column_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.column_type IS '列类型';


--
-- Name: COLUMN gen_table_column.java_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.java_type IS 'JAVA类型';


--
-- Name: COLUMN gen_table_column.java_field; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.java_field IS 'JAVA字段名';


--
-- Name: COLUMN gen_table_column.is_pk; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_pk IS '是否主键（1是）';


--
-- Name: COLUMN gen_table_column.is_increment; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_increment IS '是否自增（1是）';


--
-- Name: COLUMN gen_table_column.is_required; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_required IS '是否必填（1是）';


--
-- Name: COLUMN gen_table_column.is_insert; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_insert IS '是否为插入字段（1是）';


--
-- Name: COLUMN gen_table_column.is_edit; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_edit IS '是否编辑字段（1是）';


--
-- Name: COLUMN gen_table_column.is_list; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_list IS '是否列表字段（1是）';


--
-- Name: COLUMN gen_table_column.is_query; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.is_query IS '是否查询字段（1是）';


--
-- Name: COLUMN gen_table_column.query_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.query_type IS '查询方式（等于、不等于、大于、小于、范围）';


--
-- Name: COLUMN gen_table_column.html_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.html_type IS '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';


--
-- Name: COLUMN gen_table_column.dict_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.dict_type IS '字典类型';


--
-- Name: COLUMN gen_table_column.sort; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.sort IS '排序';


--
-- Name: COLUMN gen_table_column.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.create_by IS '创建者';


--
-- Name: COLUMN gen_table_column.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.create_time IS '创建时间';


--
-- Name: COLUMN gen_table_column.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.update_by IS '更新者';


--
-- Name: COLUMN gen_table_column.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.gen_table_column.update_time IS '更新时间';


--
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.gen_table_column_column_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.gen_table_column_column_id_seq OWNER TO system;

--
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.gen_table_column_column_id_seq OWNED BY ry_vue.gen_table_column.column_id;


--
-- Name: gen_table_table_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.gen_table_table_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.gen_table_table_id_seq OWNER TO system;

--
-- Name: gen_table_table_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.gen_table_table_id_seq OWNED BY ry_vue.gen_table.table_id;


--
-- Name: sys_config; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_config (
    config_id bigint NOT NULL,
    config_name character varying(100 char) DEFAULT NULL::varchar,
    config_key character varying(100 char) DEFAULT NULL::varchar,
    config_value character varying(500 char) DEFAULT NULL::varchar,
    config_type character(1 char) DEFAULT 'N'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char)
);


ALTER TABLE ry_vue.sys_config OWNER TO system;

--
-- Name: TABLE sys_config; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_config IS '参数配置表';


--
-- Name: COLUMN sys_config.config_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.config_id IS '参数主键';


--
-- Name: COLUMN sys_config.config_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.config_name IS '参数名称';


--
-- Name: COLUMN sys_config.config_key; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.config_key IS '参数键名';


--
-- Name: COLUMN sys_config.config_value; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.config_value IS '参数键值';


--
-- Name: COLUMN sys_config.config_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.config_type IS '系统内置（Y是 N否）';


--
-- Name: COLUMN sys_config.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.create_by IS '创建者';


--
-- Name: COLUMN sys_config.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.create_time IS '创建时间';


--
-- Name: COLUMN sys_config.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.update_by IS '更新者';


--
-- Name: COLUMN sys_config.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.update_time IS '更新时间';


--
-- Name: COLUMN sys_config.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_config.remark IS '备注';


--
-- Name: sys_config_config_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_config_config_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_config_config_id_seq OWNER TO system;

--
-- Name: sys_config_config_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_config_config_id_seq OWNED BY ry_vue.sys_config.config_id;


--
-- Name: sys_dept; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_dept (
    dept_id bigint NOT NULL,
    parent_id bigint DEFAULT 0,
    ancestors character varying(50 char) DEFAULT NULL::varchar,
    dept_name character varying(30 char) DEFAULT NULL::varchar,
    order_num integer DEFAULT 0,
    leader character varying(20 char),
    phone character varying(11 char),
    email character varying(50 char),
    status character(1 char) DEFAULT '0'::bpchar,
    del_flag character(1 char) DEFAULT '0'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone
);


ALTER TABLE ry_vue.sys_dept OWNER TO system;

--
-- Name: TABLE sys_dept; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_dept IS '部门表';


--
-- Name: COLUMN sys_dept.dept_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.dept_id IS '部门id';


--
-- Name: COLUMN sys_dept.parent_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.parent_id IS '父部门id';


--
-- Name: COLUMN sys_dept.ancestors; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.ancestors IS '祖级列表';


--
-- Name: COLUMN sys_dept.dept_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.dept_name IS '部门名称';


--
-- Name: COLUMN sys_dept.order_num; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.order_num IS '显示顺序';


--
-- Name: COLUMN sys_dept.leader; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.leader IS '负责人';


--
-- Name: COLUMN sys_dept.phone; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.phone IS '联系电话';


--
-- Name: COLUMN sys_dept.email; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.email IS '邮箱';


--
-- Name: COLUMN sys_dept.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.status IS '部门状态（0正常 1停用）';


--
-- Name: COLUMN sys_dept.del_flag; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- Name: COLUMN sys_dept.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.create_by IS '创建者';


--
-- Name: COLUMN sys_dept.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.create_time IS '创建时间';


--
-- Name: COLUMN sys_dept.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.update_by IS '更新者';


--
-- Name: COLUMN sys_dept.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dept.update_time IS '更新时间';


--
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_dept_dept_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_dept_dept_id_seq OWNER TO system;

--
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_dept_dept_id_seq OWNED BY ry_vue.sys_dept.dept_id;


--
-- Name: sys_dict_data; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_dict_data (
    dict_code bigint NOT NULL,
    dict_sort integer DEFAULT 0,
    dict_label character varying(100 char) DEFAULT NULL::varchar,
    dict_value character varying(100 char) DEFAULT NULL::varchar,
    dict_type character varying(100 char) DEFAULT NULL::varchar,
    css_class character varying(100 char),
    list_class character varying(100 char),
    is_default character(1 char) DEFAULT 'N'::bpchar,
    status character(1 char) DEFAULT '0'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char)
);


ALTER TABLE ry_vue.sys_dict_data OWNER TO system;

--
-- Name: TABLE sys_dict_data; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_dict_data IS '字典数据表';


--
-- Name: COLUMN sys_dict_data.dict_code; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.dict_code IS '字典编码';


--
-- Name: COLUMN sys_dict_data.dict_sort; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.dict_sort IS '字典排序';


--
-- Name: COLUMN sys_dict_data.dict_label; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.dict_label IS '字典标签';


--
-- Name: COLUMN sys_dict_data.dict_value; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.dict_value IS '字典键值';


--
-- Name: COLUMN sys_dict_data.dict_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.dict_type IS '字典类型';


--
-- Name: COLUMN sys_dict_data.css_class; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.css_class IS '样式属性（其他样式扩展）';


--
-- Name: COLUMN sys_dict_data.list_class; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.list_class IS '表格回显样式';


--
-- Name: COLUMN sys_dict_data.is_default; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.is_default IS '是否默认（Y是 N否）';


--
-- Name: COLUMN sys_dict_data.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.status IS '状态（0正常 1停用）';


--
-- Name: COLUMN sys_dict_data.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.create_by IS '创建者';


--
-- Name: COLUMN sys_dict_data.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.create_time IS '创建时间';


--
-- Name: COLUMN sys_dict_data.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.update_by IS '更新者';


--
-- Name: COLUMN sys_dict_data.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.update_time IS '更新时间';


--
-- Name: COLUMN sys_dict_data.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_data.remark IS '备注';


--
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_dict_data_dict_code_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_dict_data_dict_code_seq OWNER TO system;

--
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_dict_data_dict_code_seq OWNED BY ry_vue.sys_dict_data.dict_code;


--
-- Name: sys_dict_type; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_dict_type (
    dict_id bigint NOT NULL,
    dict_name character varying(100 char) DEFAULT NULL::varchar,
    dict_type character varying(100 char) DEFAULT NULL::varchar,
    status character(1 char) DEFAULT '0'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char)
);


ALTER TABLE ry_vue.sys_dict_type OWNER TO system;

--
-- Name: TABLE sys_dict_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_dict_type IS '字典类型表';


--
-- Name: COLUMN sys_dict_type.dict_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.dict_id IS '字典主键';


--
-- Name: COLUMN sys_dict_type.dict_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.dict_name IS '字典名称';


--
-- Name: COLUMN sys_dict_type.dict_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.dict_type IS '字典类型';


--
-- Name: COLUMN sys_dict_type.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.status IS '状态（0正常 1停用）';


--
-- Name: COLUMN sys_dict_type.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.create_by IS '创建者';


--
-- Name: COLUMN sys_dict_type.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.create_time IS '创建时间';


--
-- Name: COLUMN sys_dict_type.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.update_by IS '更新者';


--
-- Name: COLUMN sys_dict_type.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.update_time IS '更新时间';


--
-- Name: COLUMN sys_dict_type.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_dict_type.remark IS '备注';


--
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_dict_type_dict_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_dict_type_dict_id_seq OWNER TO system;

--
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_dict_type_dict_id_seq OWNED BY ry_vue.sys_dict_type.dict_id;


--
-- Name: sys_job; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_job (
    job_id bigint NOT NULL,
    job_name character varying(64 char) DEFAULT NULL::varchar NOT NULL,
    job_group character varying(64 char) DEFAULT 'DEFAULT'::varchar NOT NULL,
    invoke_target character varying(500 char) NOT NULL,
    cron_expression character varying(255 char) DEFAULT NULL::varchar,
    misfire_policy character varying(20 char) DEFAULT '3'::varchar,
    concurrent character(1 char) DEFAULT '1'::bpchar,
    status character(1 char) DEFAULT '0'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char) DEFAULT NULL::varchar
);


ALTER TABLE ry_vue.sys_job OWNER TO system;

--
-- Name: TABLE sys_job; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_job IS '定时任务调度表';


--
-- Name: COLUMN sys_job.job_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.job_id IS '任务ID';


--
-- Name: COLUMN sys_job.job_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.job_name IS '任务名称';


--
-- Name: COLUMN sys_job.job_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.job_group IS '任务组名';


--
-- Name: COLUMN sys_job.invoke_target; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.invoke_target IS '调用目标字符串';


--
-- Name: COLUMN sys_job.cron_expression; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.cron_expression IS 'cron执行表达式';


--
-- Name: COLUMN sys_job.misfire_policy; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.misfire_policy IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';


--
-- Name: COLUMN sys_job.concurrent; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.concurrent IS '是否并发执行（0允许 1禁止）';


--
-- Name: COLUMN sys_job.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.status IS '状态（0正常 1暂停）';


--
-- Name: COLUMN sys_job.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.create_by IS '创建者';


--
-- Name: COLUMN sys_job.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.create_time IS '创建时间';


--
-- Name: COLUMN sys_job.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.update_by IS '更新者';


--
-- Name: COLUMN sys_job.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.update_time IS '更新时间';


--
-- Name: COLUMN sys_job.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job.remark IS '备注信息';


--
-- Name: sys_job_job_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_job_job_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_job_job_id_seq OWNER TO system;

--
-- Name: sys_job_job_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_job_job_id_seq OWNED BY ry_vue.sys_job.job_id;


--
-- Name: sys_job_log; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_job_log (
    job_log_id bigint NOT NULL,
    job_name character varying(64 char) NOT NULL,
    job_group character varying(64 char) NOT NULL,
    invoke_target character varying(500 char) NOT NULL,
    job_message character varying(500 char),
    status character(1 char) DEFAULT '0'::bpchar,
    exception_info character varying(2000 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone
);


ALTER TABLE ry_vue.sys_job_log OWNER TO system;

--
-- Name: TABLE sys_job_log; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_job_log IS '定时任务调度日志表';


--
-- Name: COLUMN sys_job_log.job_log_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.job_log_id IS '任务日志ID';


--
-- Name: COLUMN sys_job_log.job_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.job_name IS '任务名称';


--
-- Name: COLUMN sys_job_log.job_group; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.job_group IS '任务组名';


--
-- Name: COLUMN sys_job_log.invoke_target; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.invoke_target IS '调用目标字符串';


--
-- Name: COLUMN sys_job_log.job_message; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.job_message IS '日志信息';


--
-- Name: COLUMN sys_job_log.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.status IS '执行状态（0正常 1失败）';


--
-- Name: COLUMN sys_job_log.exception_info; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.exception_info IS '异常信息';


--
-- Name: COLUMN sys_job_log.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_job_log.create_time IS '创建时间';


--
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_job_log_job_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_job_log_job_log_id_seq OWNER TO system;

--
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_job_log_job_log_id_seq OWNED BY ry_vue.sys_job_log.job_log_id;


--
-- Name: sys_logininfor; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_logininfor (
    info_id bigint NOT NULL,
    user_name character varying(50 char) DEFAULT NULL::varchar,
    ipaddr character varying(128 char) DEFAULT NULL::varchar,
    login_location character varying(255 char) DEFAULT NULL::varchar,
    browser character varying(50 char) DEFAULT NULL::varchar,
    os character varying(50 char) DEFAULT NULL::varchar,
    status character(1 char) DEFAULT '0'::bpchar,
    msg character varying(255 char) DEFAULT NULL::varchar,
    login_time timestamp(6) without time zone
);


ALTER TABLE ry_vue.sys_logininfor OWNER TO system;

--
-- Name: TABLE sys_logininfor; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_logininfor IS '系统访问记录';


--
-- Name: COLUMN sys_logininfor.info_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.info_id IS '访问ID';


--
-- Name: COLUMN sys_logininfor.user_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.user_name IS '用户账号';


--
-- Name: COLUMN sys_logininfor.ipaddr; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.ipaddr IS '登录IP地址';


--
-- Name: COLUMN sys_logininfor.login_location; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.login_location IS '登录地点';


--
-- Name: COLUMN sys_logininfor.browser; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.browser IS '浏览器类型';


--
-- Name: COLUMN sys_logininfor.os; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.os IS '操作系统';


--
-- Name: COLUMN sys_logininfor.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.status IS '登录状态（0成功 1失败）';


--
-- Name: COLUMN sys_logininfor.msg; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.msg IS '提示消息';


--
-- Name: COLUMN sys_logininfor.login_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_logininfor.login_time IS '访问时间';


--
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_logininfor_info_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_logininfor_info_id_seq OWNER TO system;

--
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_logininfor_info_id_seq OWNED BY ry_vue.sys_logininfor.info_id;


--
-- Name: sys_menu; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_menu (
    menu_id bigint NOT NULL,
    menu_name character varying(50 char) NOT NULL,
    parent_id bigint DEFAULT 0,
    order_num integer DEFAULT 0,
    path character varying(200 char) DEFAULT NULL::varchar,
    component character varying(255 char),
    query character varying(255 char),
    is_frame integer DEFAULT 1,
    is_cache integer DEFAULT 0,
    menu_type character(1 char) DEFAULT NULL::bpchar,
    visible character(1 char) DEFAULT '0'::bpchar,
    status character(1 char) DEFAULT '0'::bpchar,
    perms character varying(100 char),
    icon character varying(100 char) DEFAULT '#'::varchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char) DEFAULT NULL::varchar
);


ALTER TABLE ry_vue.sys_menu OWNER TO system;

--
-- Name: TABLE sys_menu; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_menu IS '菜单权限表';


--
-- Name: COLUMN sys_menu.menu_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.menu_id IS '菜单ID';


--
-- Name: COLUMN sys_menu.menu_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.menu_name IS '菜单名称';


--
-- Name: COLUMN sys_menu.parent_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.parent_id IS '父菜单ID';


--
-- Name: COLUMN sys_menu.order_num; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.order_num IS '显示顺序';


--
-- Name: COLUMN sys_menu.path; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.path IS '路由地址';


--
-- Name: COLUMN sys_menu.component; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.component IS '组件路径';


--
-- Name: COLUMN sys_menu.query; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.query IS '路由参数';


--
-- Name: COLUMN sys_menu.is_frame; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.is_frame IS '是否为外链（0是 1否）';


--
-- Name: COLUMN sys_menu.is_cache; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.is_cache IS '是否缓存（0缓存 1不缓存）';


--
-- Name: COLUMN sys_menu.menu_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.menu_type IS '菜单类型（M目录 C菜单 F按钮）';


--
-- Name: COLUMN sys_menu.visible; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.visible IS '菜单状态（0显示 1隐藏）';


--
-- Name: COLUMN sys_menu.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.status IS '菜单状态（0正常 1停用）';


--
-- Name: COLUMN sys_menu.perms; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.perms IS '权限标识';


--
-- Name: COLUMN sys_menu.icon; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.icon IS '菜单图标';


--
-- Name: COLUMN sys_menu.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.create_by IS '创建者';


--
-- Name: COLUMN sys_menu.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.create_time IS '创建时间';


--
-- Name: COLUMN sys_menu.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.update_by IS '更新者';


--
-- Name: COLUMN sys_menu.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.update_time IS '更新时间';


--
-- Name: COLUMN sys_menu.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_menu.remark IS '备注';


--
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_menu_menu_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_menu_menu_id_seq OWNER TO system;

--
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_menu_menu_id_seq OWNED BY ry_vue.sys_menu.menu_id;


--
-- Name: sys_notice; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_notice (
    notice_id bigint NOT NULL,
    notice_title character varying(50 char) NOT NULL,
    notice_type character(1 char) NOT NULL,
    notice_content blob,
    status character(1 char) DEFAULT '0'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(255 char)
);


ALTER TABLE ry_vue.sys_notice OWNER TO system;

--
-- Name: TABLE sys_notice; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_notice IS '通知公告表';


--
-- Name: COLUMN sys_notice.notice_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.notice_id IS '公告ID';


--
-- Name: COLUMN sys_notice.notice_title; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.notice_title IS '公告标题';


--
-- Name: COLUMN sys_notice.notice_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.notice_type IS '公告类型（1通知 2公告）';


--
-- Name: COLUMN sys_notice.notice_content; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.notice_content IS '公告内容';


--
-- Name: COLUMN sys_notice.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.status IS '公告状态（0正常 1关闭）';


--
-- Name: COLUMN sys_notice.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.create_by IS '创建者';


--
-- Name: COLUMN sys_notice.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.create_time IS '创建时间';


--
-- Name: COLUMN sys_notice.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.update_by IS '更新者';


--
-- Name: COLUMN sys_notice.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.update_time IS '更新时间';


--
-- Name: COLUMN sys_notice.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_notice.remark IS '备注';


--
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_notice_notice_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_notice_notice_id_seq OWNER TO system;

--
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_notice_notice_id_seq OWNED BY ry_vue.sys_notice.notice_id;


--
-- Name: sys_oper_log; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_oper_log (
    oper_id bigint NOT NULL,
    title character varying(50 char) DEFAULT NULL::varchar,
    business_type integer DEFAULT 0,
    method character varying(100 char) DEFAULT NULL::varchar,
    request_method character varying(10 char) DEFAULT NULL::varchar,
    operator_type integer DEFAULT 0,
    oper_name character varying(50 char) DEFAULT NULL::varchar,
    dept_name character varying(50 char) DEFAULT NULL::varchar,
    oper_url character varying(255 char) DEFAULT NULL::varchar,
    oper_ip character varying(128 char) DEFAULT NULL::varchar,
    oper_location character varying(255 char) DEFAULT NULL::varchar,
    oper_param character varying(2000 char) DEFAULT NULL::varchar,
    json_result character varying(2000 char) DEFAULT NULL::varchar,
    status integer DEFAULT 0,
    error_msg character varying(2000 char) DEFAULT NULL::varchar,
    oper_time timestamp(6) without time zone,
    cost_time bigint
);


ALTER TABLE ry_vue.sys_oper_log OWNER TO system;

--
-- Name: TABLE sys_oper_log; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_oper_log IS '操作日志记录';


--
-- Name: COLUMN sys_oper_log.oper_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_id IS '日志主键';


--
-- Name: COLUMN sys_oper_log.title; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.title IS '模块标题';


--
-- Name: COLUMN sys_oper_log.business_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.business_type IS '业务类型（0其它 1新增 2修改 3删除）';


--
-- Name: COLUMN sys_oper_log.method; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.method IS '方法名称';


--
-- Name: COLUMN sys_oper_log.request_method; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.request_method IS '请求方式';


--
-- Name: COLUMN sys_oper_log.operator_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.operator_type IS '操作类别（0其它 1后台用户 2手机端用户）';


--
-- Name: COLUMN sys_oper_log.oper_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_name IS '操作人员';


--
-- Name: COLUMN sys_oper_log.dept_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.dept_name IS '部门名称';


--
-- Name: COLUMN sys_oper_log.oper_url; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_url IS '请求URL';


--
-- Name: COLUMN sys_oper_log.oper_ip; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_ip IS '主机地址';


--
-- Name: COLUMN sys_oper_log.oper_location; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_location IS '操作地点';


--
-- Name: COLUMN sys_oper_log.oper_param; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_param IS '请求参数';


--
-- Name: COLUMN sys_oper_log.json_result; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.json_result IS '返回参数';


--
-- Name: COLUMN sys_oper_log.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.status IS '操作状态（0正常 1异常）';


--
-- Name: COLUMN sys_oper_log.error_msg; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.error_msg IS '错误消息';


--
-- Name: COLUMN sys_oper_log.oper_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.oper_time IS '操作时间';


--
-- Name: COLUMN sys_oper_log.cost_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_oper_log.cost_time IS '消耗时间';


--
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_oper_log_oper_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_oper_log_oper_id_seq OWNER TO system;

--
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_oper_log_oper_id_seq OWNED BY ry_vue.sys_oper_log.oper_id;


--
-- Name: sys_post; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_post (
    post_id bigint NOT NULL,
    post_code character varying(64 char) NOT NULL,
    post_name character varying(50 char) NOT NULL,
    post_sort integer NOT NULL,
    status character(1 char) NOT NULL,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char)
);


ALTER TABLE ry_vue.sys_post OWNER TO system;

--
-- Name: TABLE sys_post; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_post IS '岗位信息表';


--
-- Name: COLUMN sys_post.post_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.post_id IS '岗位ID';


--
-- Name: COLUMN sys_post.post_code; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.post_code IS '岗位编码';


--
-- Name: COLUMN sys_post.post_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.post_name IS '岗位名称';


--
-- Name: COLUMN sys_post.post_sort; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.post_sort IS '显示顺序';


--
-- Name: COLUMN sys_post.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.status IS '状态（0正常 1停用）';


--
-- Name: COLUMN sys_post.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.create_by IS '创建者';


--
-- Name: COLUMN sys_post.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.create_time IS '创建时间';


--
-- Name: COLUMN sys_post.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.update_by IS '更新者';


--
-- Name: COLUMN sys_post.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.update_time IS '更新时间';


--
-- Name: COLUMN sys_post.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_post.remark IS '备注';


--
-- Name: sys_post_post_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_post_post_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_post_post_id_seq OWNER TO system;

--
-- Name: sys_post_post_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_post_post_id_seq OWNED BY ry_vue.sys_post.post_id;


--
-- Name: sys_role; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_role (
    role_id bigint NOT NULL,
    role_name character varying(30 char) NOT NULL,
    role_key character varying(100 char) NOT NULL,
    role_sort integer NOT NULL,
    data_scope character(1 char) DEFAULT '1'::bpchar,
    menu_check_strictly tinyint DEFAULT 1,
    dept_check_strictly tinyint DEFAULT 1,
    status character(1 char) NOT NULL,
    del_flag character(1 char) DEFAULT '0'::bpchar,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char)
);


ALTER TABLE ry_vue.sys_role OWNER TO system;

--
-- Name: TABLE sys_role; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_role IS '角色信息表';


--
-- Name: COLUMN sys_role.role_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.role_id IS '角色ID';


--
-- Name: COLUMN sys_role.role_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.role_name IS '角色名称';


--
-- Name: COLUMN sys_role.role_key; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.role_key IS '角色权限字符串';


--
-- Name: COLUMN sys_role.role_sort; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.role_sort IS '显示顺序';


--
-- Name: COLUMN sys_role.data_scope; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.data_scope IS '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）';


--
-- Name: COLUMN sys_role.menu_check_strictly; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.menu_check_strictly IS '菜单树选择项是否关联显示';


--
-- Name: COLUMN sys_role.dept_check_strictly; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.dept_check_strictly IS '部门树选择项是否关联显示';


--
-- Name: COLUMN sys_role.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.status IS '角色状态（0正常 1停用）';


--
-- Name: COLUMN sys_role.del_flag; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- Name: COLUMN sys_role.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.create_by IS '创建者';


--
-- Name: COLUMN sys_role.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.create_time IS '创建时间';


--
-- Name: COLUMN sys_role.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.update_by IS '更新者';


--
-- Name: COLUMN sys_role.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.update_time IS '更新时间';


--
-- Name: COLUMN sys_role.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role.remark IS '备注';


--
-- Name: sys_role_dept; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_role_dept (
    role_id bigint NOT NULL,
    dept_id bigint NOT NULL
);


ALTER TABLE ry_vue.sys_role_dept OWNER TO system;

--
-- Name: TABLE sys_role_dept; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_role_dept IS '角色和部门关联表';


--
-- Name: COLUMN sys_role_dept.role_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role_dept.role_id IS '角色ID';


--
-- Name: COLUMN sys_role_dept.dept_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role_dept.dept_id IS '部门ID';


--
-- Name: sys_role_menu; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_role_menu (
    role_id bigint NOT NULL,
    menu_id bigint NOT NULL
);


ALTER TABLE ry_vue.sys_role_menu OWNER TO system;

--
-- Name: TABLE sys_role_menu; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_role_menu IS '角色和菜单关联表';


--
-- Name: COLUMN sys_role_menu.role_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role_menu.role_id IS '角色ID';


--
-- Name: COLUMN sys_role_menu.menu_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_role_menu.menu_id IS '菜单ID';


--
-- Name: sys_role_role_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_role_role_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_role_role_id_seq OWNER TO system;

--
-- Name: sys_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_role_role_id_seq OWNED BY ry_vue.sys_role.role_id;


--
-- Name: sys_user; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_user (
    user_id bigint NOT NULL,
    dept_id bigint,
    user_name character varying(30 char) NOT NULL,
    nick_name character varying(30 char) NOT NULL,
    user_type character varying(2 char) DEFAULT '00'::varchar,
    email character varying(50 char) DEFAULT NULL::varchar,
    phonenumber character varying(11 char) DEFAULT NULL::varchar,
    sex character(1 char) DEFAULT '0'::bpchar,
    avatar character varying(100 char) DEFAULT NULL::varchar,
    password character varying(100 char) DEFAULT NULL::varchar,
    status character(1 char) DEFAULT '0'::bpchar,
    del_flag character(1 char) DEFAULT '0'::bpchar,
    login_ip character varying(128 char) DEFAULT NULL::varchar,
    login_date timestamp(6) without time zone,
    create_by character varying(64 char) DEFAULT NULL::varchar,
    create_time timestamp(6) without time zone,
    update_by character varying(64 char) DEFAULT NULL::varchar,
    update_time timestamp(6) without time zone,
    remark character varying(500 char)
);


ALTER TABLE ry_vue.sys_user OWNER TO system;

--
-- Name: TABLE sys_user; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_user IS '用户信息表';


--
-- Name: COLUMN sys_user.user_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.user_id IS '用户ID';


--
-- Name: COLUMN sys_user.dept_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.dept_id IS '部门ID';


--
-- Name: COLUMN sys_user.user_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.user_name IS '用户账号';


--
-- Name: COLUMN sys_user.nick_name; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.nick_name IS '用户昵称';


--
-- Name: COLUMN sys_user.user_type; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.user_type IS '用户类型（00系统用户）';


--
-- Name: COLUMN sys_user.email; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.email IS '用户邮箱';


--
-- Name: COLUMN sys_user.phonenumber; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.phonenumber IS '手机号码';


--
-- Name: COLUMN sys_user.sex; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.sex IS '用户性别（0男 1女 2未知）';


--
-- Name: COLUMN sys_user.avatar; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.avatar IS '头像地址';


--
-- Name: COLUMN sys_user.password; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.password IS '密码';


--
-- Name: COLUMN sys_user.status; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.status IS '帐号状态（0正常 1停用）';


--
-- Name: COLUMN sys_user.del_flag; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- Name: COLUMN sys_user.login_ip; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.login_ip IS '最后登录IP';


--
-- Name: COLUMN sys_user.login_date; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.login_date IS '最后登录时间';


--
-- Name: COLUMN sys_user.create_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.create_by IS '创建者';


--
-- Name: COLUMN sys_user.create_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.create_time IS '创建时间';


--
-- Name: COLUMN sys_user.update_by; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.update_by IS '更新者';


--
-- Name: COLUMN sys_user.update_time; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.update_time IS '更新时间';


--
-- Name: COLUMN sys_user.remark; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user.remark IS '备注';


--
-- Name: sys_user_post; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_user_post (
    user_id bigint NOT NULL,
    post_id bigint NOT NULL
);


ALTER TABLE ry_vue.sys_user_post OWNER TO system;

--
-- Name: TABLE sys_user_post; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_user_post IS '用户与岗位关联表';


--
-- Name: COLUMN sys_user_post.user_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user_post.user_id IS '用户ID';


--
-- Name: COLUMN sys_user_post.post_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user_post.post_id IS '岗位ID';


--
-- Name: sys_user_role; Type: TABLE; Schema: ry_vue; Owner: system
--

SET escape = off;
CREATE TABLE ry_vue.sys_user_role (
    user_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE ry_vue.sys_user_role OWNER TO system;

--
-- Name: TABLE sys_user_role; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON TABLE ry_vue.sys_user_role IS '用户和角色关联表';


--
-- Name: COLUMN sys_user_role.user_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user_role.user_id IS '用户ID';


--
-- Name: COLUMN sys_user_role.role_id; Type: COMMENT; Schema: ry_vue; Owner: system
--

COMMENT ON COLUMN ry_vue.sys_user_role.role_id IS '角色ID';


--
-- Name: sys_user_user_id_seq; Type: SEQUENCE; Schema: ry_vue; Owner: system
--

CREATE SEQUENCE ry_vue.sys_user_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE ry_vue.sys_user_user_id_seq OWNER TO system;

--
-- Name: sys_user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: ry_vue; Owner: system
--

ALTER SEQUENCE ry_vue.sys_user_user_id_seq OWNED BY ry_vue.sys_user.user_id;


--
-- Name: gen_table table_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.gen_table ALTER COLUMN table_id SET DEFAULT nextval('ry_vue.gen_table_table_id_seq'::regclass);


--
-- Name: gen_table_column column_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.gen_table_column ALTER COLUMN column_id SET DEFAULT nextval('ry_vue.gen_table_column_column_id_seq'::regclass);


--
-- Name: sys_config config_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_config ALTER COLUMN config_id SET DEFAULT nextval('ry_vue.sys_config_config_id_seq'::regclass);


--
-- Name: sys_dept dept_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dept ALTER COLUMN dept_id SET DEFAULT nextval('ry_vue.sys_dept_dept_id_seq'::regclass);


--
-- Name: sys_dict_data dict_code; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dict_data ALTER COLUMN dict_code SET DEFAULT nextval('ry_vue.sys_dict_data_dict_code_seq'::regclass);


--
-- Name: sys_dict_type dict_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dict_type ALTER COLUMN dict_id SET DEFAULT nextval('ry_vue.sys_dict_type_dict_id_seq'::regclass);


--
-- Name: sys_job job_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_job ALTER COLUMN job_id SET DEFAULT nextval('ry_vue.sys_job_job_id_seq'::regclass);


--
-- Name: sys_job_log job_log_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_job_log ALTER COLUMN job_log_id SET DEFAULT nextval('ry_vue.sys_job_log_job_log_id_seq'::regclass);


--
-- Name: sys_logininfor info_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_logininfor ALTER COLUMN info_id SET DEFAULT nextval('ry_vue.sys_logininfor_info_id_seq'::regclass);


--
-- Name: sys_menu menu_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_menu ALTER COLUMN menu_id SET DEFAULT nextval('ry_vue.sys_menu_menu_id_seq'::regclass);


--
-- Name: sys_notice notice_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_notice ALTER COLUMN notice_id SET DEFAULT nextval('ry_vue.sys_notice_notice_id_seq'::regclass);


--
-- Name: sys_oper_log oper_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_oper_log ALTER COLUMN oper_id SET DEFAULT nextval('ry_vue.sys_oper_log_oper_id_seq'::regclass);


--
-- Name: sys_post post_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_post ALTER COLUMN post_id SET DEFAULT nextval('ry_vue.sys_post_post_id_seq'::regclass);


--
-- Name: sys_role role_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_role ALTER COLUMN role_id SET DEFAULT nextval('ry_vue.sys_role_role_id_seq'::regclass);


--
-- Name: sys_user user_id; Type: DEFAULT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_user ALTER COLUMN user_id SET DEFAULT nextval('ry_vue.sys_user_user_id_seq'::regclass);


--
-- Data for Name: QRTZ_BLOB_TRIGGERS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_BLOB_TRIGGERS" (sched_name, trigger_name, trigger_group, blob_data) FROM stdin;
\.


--
-- Data for Name: QRTZ_CALENDARS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_CALENDARS" (sched_name, calendar_name, calendar) FROM stdin;
\.


--
-- Data for Name: QRTZ_CRON_TRIGGERS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_CRON_TRIGGERS" (sched_name, trigger_name, trigger_group, cron_expression, time_zone_id) FROM stdin;
\.


--
-- Data for Name: QRTZ_FIRED_TRIGGERS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_FIRED_TRIGGERS" (sched_name, entry_id, trigger_name, trigger_group, instance_name, fired_time, sched_time, priority, state, job_name, job_group, is_nonconcurrent, requests_recovery) FROM stdin;
\.


--
-- Data for Name: QRTZ_JOB_DETAILS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_JOB_DETAILS" (sched_name, job_name, job_group, description, job_class_name, is_durable, is_nonconcurrent, is_update_data, requests_recovery, job_data) FROM stdin;
\.


--
-- Data for Name: QRTZ_LOCKS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_LOCKS" (sched_name, lock_name) FROM stdin;
\.


--
-- Data for Name: QRTZ_PAUSED_TRIGGER_GRPS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_PAUSED_TRIGGER_GRPS" (sched_name, trigger_group) FROM stdin;
\.


--
-- Data for Name: QRTZ_SCHEDULER_STATE; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_SCHEDULER_STATE" (sched_name, instance_name, last_checkin_time, checkin_interval) FROM stdin;
\.


--
-- Data for Name: QRTZ_SIMPLE_TRIGGERS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_SIMPLE_TRIGGERS" (sched_name, trigger_name, trigger_group, repeat_count, repeat_interval, times_triggered) FROM stdin;
\.


--
-- Data for Name: QRTZ_SIMPROP_TRIGGERS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_SIMPROP_TRIGGERS" (sched_name, trigger_name, trigger_group, str_prop_1, str_prop_2, str_prop_3, int_prop_1, int_prop_2, long_prop_1, long_prop_2, dec_prop_1, dec_prop_2, bool_prop_1, bool_prop_2) FROM stdin;
\.


--
-- Data for Name: QRTZ_TRIGGERS; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue."QRTZ_TRIGGERS" (sched_name, trigger_name, trigger_group, job_name, job_group, description, next_fire_time, prev_fire_time, priority, trigger_state, trigger_type, start_time, end_time, calendar_name, misfire_instr, job_data) FROM stdin;
\.


--
-- Data for Name: gen_table; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark, tpl_web_type) FROM stdin;
3	cdp_data_analysis	数据分析	\N	\N	DataAnalysis	crud	com.ruoyi.analysis	system	analysis	数据分析	wuhuc	0	/	{}	admin	2023-06-07 07:30:35		2023-06-07 07:32:47	\N	\N
4	bulletin_board	看板表	\N	\N	BulletinBoard	crud	com.ruoyi.system	system	board	看板	wuhuc	0	/	{}	admin	2023-06-13 04:20:42		2023-06-13 04:21:43	\N	\N
5	deemed_report	视同报告	\N	\N	DeemedReport	crud	com/ai/business/report	report	report	视同报告	wuhuc	0	/	{}	admin	2023-08-25 02:33:28		2023-08-25 02:36:49	\N	\N
6	expert_type	专家类型表			ExpertType	tree	com.ruoyi.system	system	type	专家类型	wuhuc	0	/	{"treeCode":"id","treeName":"name","treeParentCode":"parent_id"}	admin	2023-09-13 02:02:07		2023-09-13 02:06:20	\N	\N
7	expert_information	专家信息表	\N	\N	ExpertInformation	crud	com.ruoyi.system	system	information	专家信息	wuhuc	0	/	{}	admin	2023-09-13 04:18:06		2023-09-13 04:21:46	\N	\N
8	problem_form	问专家_问题表	\N	\N	ProblemForm	crud	com.ruoyi.system	system	form	问专家_问题	wuhuc	0	/	\N	admin	2023-09-14 12:39:24		\N	\N	\N
2	vehicle_certificate	车辆证	\N	\N	VehicleCertificate	crud	com.ruoyi.system	system	certificate	车辆证	wuhuc	0	/	{}	admin	2023-05-23 09:38:13		2023-12-21 20:24:34	\N	\N
\.


--
-- Data for Name: gen_table_column; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_by, create_time, update_by, update_time) FROM stdin;
27	3	id	\N	bigint(20)	Long	id	1	0	\N	1	\N	\N	\N	EQ	input		1	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
28	3	create_by	\N	varchar(255)	String	createBy	0	0	1	1	\N	\N	\N	EQ	input		2	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
29	3	create_time	\N	datetime	LocalDateTime	createTime	0	0	1	1	\N	\N	\N	EQ	datetime		3	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
30	3	update_by	\N	varchar(255)	String	updateBy	0	0	\N	1	1	\N	\N	EQ	input		4	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
31	3	update_time	\N	datetime	LocalDateTime	updateTime	0	0	\N	1	1	\N	\N	EQ	datetime		5	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
32	3	analytical_methods	分析方法	varchar(255)	String	analyticalMethods	0	0	\N	1	1	1	1	EQ	input		6	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
33	3	analysis_name	分析名称	varchar(255)	String	analysisName	0	0	\N	1	1	1	1	LIKE	input		7	admin	2023-06-07 07:30:36		2023-06-07 07:32:47
34	3	start_time	开始时间	datetime	LocalDateTime	startTime	0	0	\N	1	1	1	1	EQ	datetime		8	admin	2023-06-07 07:30:36		2023-06-07 07:32:48
35	3	completion_time	完成时间	datetime	LocalDateTime	completionTime	0	0	\N	1	1	1	1	EQ	datetime		9	admin	2023-06-07 07:30:36		2023-06-07 07:32:48
36	3	calculation_status	计算状态	varchar(255)	String	calculationStatus	0	0	\N	1	1	1	1	EQ	radio		10	admin	2023-06-07 07:30:36		2023-06-07 07:32:48
37	3	data_configuration	数据配置	json	String	dataConfiguration	0	0	\N	0	0	0	0	EQ	\N		11	admin	2023-06-07 07:30:37		2023-06-07 07:32:48
38	4	id	\N	bigint(20)	Long	id	1	1	\N	1	\N	\N	\N	EQ	input		1	admin	2023-06-13 04:20:42		2023-06-13 04:21:43
39	4	name	看板名称	varchar(255)	String	name	0	0	\N	1	1	1	1	LIKE	input		2	admin	2023-06-13 04:20:42		2023-06-13 04:21:43
40	4	sharer	分享人name	varchar(255)	String	sharer	0	0	\N	1	1	1	1	EQ	input		3	admin	2023-06-13 04:20:42		2023-06-13 04:21:43
41	4	share_time	分享时间	datetime	LocalDateTime	shareTime	0	0	\N	1	1	1	1	EQ	datetime		4	admin	2023-06-13 04:20:43		2023-06-13 04:21:43
42	4	listing_id	分类id	bigint(20)	Long	listingId	0	0	\N	1	1	1	1	EQ	input		5	admin	2023-06-13 04:20:43		2023-06-13 04:21:43
43	5	id	\N	bigint(20)	Long	id	1	0	\N	1	\N	\N	\N	EQ	input		1	admin	2023-08-25 02:33:28		2023-08-25 02:36:49
44	5	create_by	\N	varchar(255)	String	createBy	0	0	1	1	\N	\N	\N	EQ	input		2	admin	2023-08-25 02:33:28		2023-08-25 02:36:49
45	5	create_time	\N	datetime	Date	createTime	0	0	1	1	\N	\N	\N	EQ	datetime		3	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
46	5	update_by	\N	varchar(255)	String	updateBy	0	0	\N	1	1	\N	\N	EQ	input		4	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
47	5	update_time	\N	datetime	Date	updateTime	0	0	\N	1	1	\N	\N	EQ	datetime		5	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
48	5	del_flag	0-未删除  1已删除	varchar(1)	String	delFlag	0	0	1	1	\N	\N	\N	EQ	input		6	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
49	5	product_id	产品ID	varchar(255)	String	productId	0	0	\N	1	1	1	1	EQ	input		7	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
50	5	product_model	产品型号	varchar(255)	String	productModel	0	0	\N	1	1	1	1	EQ	input		8	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
51	5	product_number	产品编号	varchar(255)	String	productNumber	0	0	\N	1	1	1	1	EQ	input		9	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
52	5	product_url	产品访问路径	varchar(255)	String	productUrl	0	0	\N	1	1	1	1	EQ	input		10	admin	2023-08-25 02:33:29		2023-08-25 02:36:50
53	6	id	id	int(11)	Long	id	1	1	\N	1	\N	\N	\N	EQ	input		1	admin	2023-09-13 02:02:08		2023-09-13 02:06:20
54	6	parent_id	父级id	int(11)	Long	parentId	0	0	1	1	1	1	1	EQ	input		2	admin	2023-09-13 02:02:08		2023-09-13 02:06:20
55	6	name	名称	varchar(50)	String	name	0	0	1	1	1	1	1	LIKE	input		3	admin	2023-09-13 02:02:08		2023-09-13 02:06:20
56	6	sort	排序	int(11)	Long	sort	0	0	\N	1	1	1	1	EQ	input		4	admin	2023-09-13 02:02:08		2023-09-13 02:06:20
57	6	description	描述	varchar(200)	String	description	0	0	\N	1	1	1	1	EQ	input		5	admin	2023-09-13 02:02:08		2023-09-13 02:06:20
58	7	id	\N	bigint(20)	Long	id	1	0	\N	1	\N	\N	\N	EQ	input		1	admin	2023-09-13 04:18:07		2023-09-13 04:21:46
59	7	create_by	\N	varchar(255)	String	createBy	0	0	1	1	\N	\N	\N	EQ	input		2	admin	2023-09-13 04:18:07		2023-09-13 04:21:46
60	7	create_time	\N	datetime	Date	createTime	0	0	1	1	\N	\N	\N	EQ	datetime		3	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
61	7	update_by	\N	varchar(255)	String	updateBy	0	0	\N	1	1	\N	\N	EQ	input		4	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
62	7	update_time	\N	datetime	Date	updateTime	0	0	\N	1	1	\N	\N	EQ	datetime		5	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
63	7	del_flag	0-未删除  1已删除	varchar(1)	String	delFlag	0	0	1	1	\N	\N	\N	EQ	input		6	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
64	7	type	专家分类	varchar(255)	String	type	0	0	\N	1	1	1	1	EQ	select		7	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
65	7	sub_type	专家类型	varchar(255)	String	subType	0	0	\N	1	1	1	1	EQ	select		8	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
66	7	name	专家名称	varchar(255)	String	name	0	0	\N	1	1	1	1	LIKE	input		9	admin	2023-09-13 04:18:07		2023-09-13 04:21:47
67	7	phone	手机号	varchar(255)	String	phone	0	0	\N	1	1	1	1	LIKE	input		10	admin	2023-09-13 04:18:08		2023-09-13 04:21:47
68	7	address	地址	varchar(255)	String	address	0	0	\N	1	1	1	1	LIKE	input		11	admin	2023-09-13 04:18:08		2023-09-13 04:21:47
69	7	responsible_area	负责区域	varchar(255)	String	responsibleArea	0	0	\N	1	1	1	1	EQ	input		12	admin	2023-09-13 04:18:08		2023-09-13 04:21:47
70	7	certificate	证书	varchar(255)	String	certificate	0	0	\N	1	1	1	1	EQ	input		13	admin	2023-09-13 04:18:08		2023-09-13 04:21:48
71	7	introduce	介绍	varchar(255)	String	introduce	0	0	\N	1	1	1	1	EQ	input		14	admin	2023-09-13 04:18:08		2023-09-13 04:21:48
72	8	id	\N	bigint(20)	Long	id	1	0	\N	1	\N	\N	\N	EQ	input		1	admin	2023-09-14 12:39:24		\N
73	8	create_by	\N	varchar(255)	String	createBy	0	0	1	1	\N	\N	\N	EQ	input		2	admin	2023-09-14 12:39:24		\N
74	8	create_time	\N	datetime	Date	createTime	0	0	1	1	\N	\N	\N	EQ	datetime		3	admin	2023-09-14 12:39:24		\N
75	8	title	标题	varchar(255)	String	title	0	0	\N	1	1	1	1	EQ	input		4	admin	2023-09-14 12:39:25		\N
76	8	describe	描述	varchar(255)	String	describe	0	0	\N	1	1	1	1	EQ	input		5	admin	2023-09-14 12:39:25		\N
77	8	photo	照片	varchar(255)	String	photo	0	0	\N	1	1	1	1	EQ	input		6	admin	2023-09-14 12:39:25		\N
78	8	expert_id	专家id	varchar(255)	String	expertId	0	0	\N	1	1	1	1	EQ	input		7	admin	2023-09-14 12:39:25		\N
79	8	reply_message	回复信息	varchar(255)	String	replyMessage	0	0	\N	1	1	1	1	EQ	input		8	admin	2023-09-14 12:39:25		\N
14	2	id	\N	bigint(20)	Long	id	1	1	\N	1	\N	\N	\N	EQ	input	\N	1	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
15	2	create_by	\N	bigint(20)	Long	createBy	0	0	1	1	\N	\N	\N	EQ	input	\N	2	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
16	2	create_time	创建时间	datetime	LocalDateTime	createTime	0	0	1	1	\N	\N	\N	EQ	datetime	\N	3	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
17	2	update_by	\N	bigint(20)	Long	updateBy	0	0	\N	1	1	\N	\N	EQ	input	\N	4	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
18	2	update_time	\N	datetime	LocalDateTime	updateTime	0	0	\N	1	1	\N	\N	EQ	datetime	\N	5	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
19	2	del_flag	0-未删除  1已删除	varchar(1)	String	delFlag	0	0	1	1	\N	\N	\N	EQ	input	\N	6	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
20	2	exhibition_group_id	展团id	varchar(255)	String	exhibitionGroupId	0	0	\N	1	1	1	1	EQ	input	\N	7	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
21	2	document_type	证件种类 0=贵宾车辆通行证,1=工作车辆通行证,2=展会车辆通行证	varchar(255)	String	documentType	0	0	\N	1	1	1	1	EQ	select	\N	8	admin	2023-05-23 09:38:13	\N	2023-12-21 20:24:34
22	2	unit_name	单位名称	varchar(255)	String	unitName	0	0	\N	1	1	1	1	LIKE	input	\N	9	admin	2023-05-23 09:38:14	\N	2023-12-21 20:24:34
23	2	license_plate_number	车牌号	varchar(255)	String	licensePlateNumber	0	0	\N	1	1	1	1	EQ	input	\N	10	admin	2023-05-23 09:38:14	\N	2023-12-21 20:24:34
24	2	state	状态 0-待审核 1-已拒绝 2-已通过	varchar(5)	String	state	0	0	\N	1	1	1	1	EQ	input	\N	11	admin	2023-05-23 09:38:14	\N	2023-12-21 20:24:34
25	2	audit_time	审核时间	datetime	LocalDateTime	auditTime	0	0	\N	1	1	1	1	BETWEEN	datetime	\N	12	admin	2023-05-23 09:38:14	\N	2023-12-21 20:24:34
26	2	explains	说明	text	String	explains	0	0	\N	1	1	1	1	EQ	textarea	\N	13	admin	2023-05-23 09:38:14	\N	2023-12-21 20:24:34
\.


--
-- Data for Name: sys_config; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) FROM stdin;
2	用户管理-账号初始密码	sys.user.initPassword	123456	Y	admin	2023-05-22 09:36:17		\N	初始化密码 123456
3	主框架页-侧边栏主题	sys.index.sideTheme	theme-dark	Y	admin	2023-05-22 09:36:18		\N	深色主题theme-dark，浅色主题theme-light
4	账号自助-验证码开关	sys.account.captchaEnabled	true	Y	admin	2023-05-22 09:36:19		\N	是否开启验证码功能（true开启，false关闭）
5	账号自助-是否开启用户注册功能	sys.account.registerUser	false	Y	admin	2023-05-22 09:36:19		\N	是否开启注册用户功能（true开启，false关闭）
1	主框架页-默认皮肤样式名称	sys.index.skinName	skin-blue	Y	admin	2023-05-22 09:36:17	admin	2023-12-21 20:15:25	蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow
\.


--
-- Data for Name: sys_dept; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time) FROM stdin;
102	100	0,100	长沙分公司	2	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:26		\N
108	102	0,100,102	市场部门	1	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:30		\N
109	102	0,100,102	财务部门	2	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:31		\N
103	101	0,100,101	研发部门	1	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:27		\N
104	101	0,100,101	市场部门	2	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:27		\N
105	101	0,100,101	测试部门	3	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:28		\N
106	101	0,100,101	财务部门	4	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:29		\N
107	101	0,100,101	运维部门	5	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:29		\N
101	100	0,100	深圳总公司	1	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:25	admin	2023-12-21 20:15:09
100	0	0	若依科技	0	若依	15888888888	ry@qq.com	0	0	admin	2023-05-22 09:33:25		\N
\.


--
-- Data for Name: sys_dict_data; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
4	1	显示	0	sys_show_hide		primary	Y	0	admin	2023-05-22 09:35:58		\N	显示菜单
5	2	隐藏	1	sys_show_hide		danger	N	0	admin	2023-05-22 09:35:58		\N	隐藏菜单
6	1	正常	0	sys_normal_disable		primary	Y	0	admin	2023-05-22 09:35:59		\N	正常状态
7	2	停用	1	sys_normal_disable		danger	N	0	admin	2023-05-22 09:36:00		\N	停用状态
8	1	正常	0	sys_job_status		primary	Y	0	admin	2023-05-22 09:36:00		\N	正常状态
9	2	暂停	1	sys_job_status		danger	N	0	admin	2023-05-22 09:36:01		\N	停用状态
10	1	默认	DEFAULT	sys_job_group			Y	0	admin	2023-05-22 09:36:01		\N	默认分组
11	2	系统	SYSTEM	sys_job_group			N	0	admin	2023-05-22 09:36:02		\N	系统分组
12	1	是	Y	sys_yes_no		primary	Y	0	admin	2023-05-22 09:36:03		\N	系统默认是
13	2	否	N	sys_yes_no		danger	N	0	admin	2023-05-22 09:36:04		\N	系统默认否
14	1	通知	1	sys_notice_type		warning	Y	0	admin	2023-05-22 09:36:05		\N	通知
15	2	公告	2	sys_notice_type		success	N	0	admin	2023-05-22 09:36:06		\N	公告
16	1	正常	0	sys_notice_status		primary	Y	0	admin	2023-05-22 09:36:06		\N	正常状态
17	2	关闭	1	sys_notice_status		danger	N	0	admin	2023-05-22 09:36:07		\N	关闭状态
18	99	其他	0	sys_oper_type		info	N	0	admin	2023-05-22 09:36:08		\N	其他操作
19	1	新增	1	sys_oper_type		info	N	0	admin	2023-05-22 09:36:08		\N	新增操作
20	2	修改	2	sys_oper_type		info	N	0	admin	2023-05-22 09:36:09		\N	修改操作
21	3	删除	3	sys_oper_type		danger	N	0	admin	2023-05-22 09:36:10		\N	删除操作
22	4	授权	4	sys_oper_type		primary	N	0	admin	2023-05-22 09:36:10		\N	授权操作
23	5	导出	5	sys_oper_type		warning	N	0	admin	2023-05-22 09:36:11		\N	导出操作
24	6	导入	6	sys_oper_type		warning	N	0	admin	2023-05-22 09:36:12		\N	导入操作
25	7	强退	7	sys_oper_type		danger	N	0	admin	2023-05-22 09:36:12		\N	强退操作
26	8	生成代码	8	sys_oper_type		warning	N	0	admin	2023-05-22 09:36:13		\N	生成操作
27	9	清空数据	9	sys_oper_type		danger	N	0	admin	2023-05-22 09:36:13		\N	清空操作
28	1	成功	0	sys_common_status		primary	N	0	admin	2023-05-22 09:36:14		\N	正常状态
29	2	失败	1	sys_common_status		danger	N	0	admin	2023-05-22 09:36:15		\N	停用状态
1	1	男	0	sys_user_sex			Y	0	admin	2023-05-22 09:35:56		\N	性别男
2	2	女	1	sys_user_sex			N	0	admin	2023-05-22 09:35:56		\N	性别女
3	3	未知	2	sys_user_sex			N	0	admin	2023-05-22 09:35:57		\N	性别未知
\.


--
-- Data for Name: sys_dict_type; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
2	菜单状态	sys_show_hide	0	admin	2023-05-22 09:35:48		\N	菜单状态列表
3	系统开关	sys_normal_disable	0	admin	2023-05-22 09:35:49		\N	系统开关列表
4	任务状态	sys_job_status	0	admin	2023-05-22 09:35:50		\N	任务状态列表
5	任务分组	sys_job_group	0	admin	2023-05-22 09:35:50		\N	任务分组列表
6	系统是否	sys_yes_no	0	admin	2023-05-22 09:35:51		\N	系统是否列表
7	通知类型	sys_notice_type	0	admin	2023-05-22 09:35:52		\N	通知类型列表
8	通知状态	sys_notice_status	0	admin	2023-05-22 09:35:52		\N	通知状态列表
9	操作类型	sys_oper_type	0	admin	2023-05-22 09:35:53		\N	操作类型列表
10	系统状态	sys_common_status	0	admin	2023-05-22 09:35:54		\N	登录状态列表
1	用户性别	sys_user_sex	0	admin	2023-05-22 09:35:48	admin	2023-12-21 20:15:19	用户性别列表
\.


--
-- Data for Name: sys_job; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	系统默认（无参）	DEFAULT	ryTask.ryNoParams	0/10 * * * * ?	3	1	1	admin	2023-05-22 09:36:23		\N	
3	系统默认（多参）	DEFAULT	ryTask.ryMultipleParams('ry', true, 2000L, 316.50D, 100)	0/20 * * * * ?	3	1	1	admin	2023-05-22 09:36:24		\N	
2	系统默认（有参）	DEFAULT	ryTask.ryParams('ry')	0/15 * * * * ?	3	1	1	admin	2023-05-22 09:36:23		2023-12-21 20:15:47	
\.


--
-- Data for Name: sys_job_log; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_job_log (job_log_id, job_name, job_group, invoke_target, job_message, status, exception_info, create_time) FROM stdin;
1	系统默认（有参）	DEFAULT	ryTask.ryParams('ry')	系统默认（有参） 总共耗时：0毫秒	0	\N	2023-12-21 20:15:46
\.


--
-- Data for Name: sys_logininfor; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_logininfor (info_id, user_name, ipaddr, login_location, browser, os, status, msg, login_time) FROM stdin;
\.


--
-- Data for Name: sys_menu; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	系统管理	0	1	system	\N		1	0	M	0	0		system	admin	2023-05-22 09:33:42		\N	系统管理目录
2	系统监控	0	2	monitor	\N		1	0	M	0	0		monitor	admin	2023-05-22 09:33:43		\N	系统监控目录
3	系统工具	0	3	tool	\N		1	0	M	0	0		tool	admin	2023-05-22 09:33:44		\N	系统工具目录
4	若依官网	0	4	http://ruoyi.vip	\N		0	0	M	0	0		guide	admin	2023-05-22 09:33:44		\N	若依官网地址
100	用户管理	1	1	user	system/user/index		1	0	C	0	0	system:user:list	user	admin	2023-05-22 09:33:45		\N	用户管理菜单
101	角色管理	1	2	role	system/role/index		1	0	C	0	0	system:role:list	peoples	admin	2023-05-22 09:33:46		\N	角色管理菜单
102	菜单管理	1	3	menu	system/menu/index		1	0	C	0	0	system:menu:list	tree-table	admin	2023-05-22 09:33:46		\N	菜单管理菜单
103	部门管理	1	4	dept	system/dept/index		1	0	C	0	0	system:dept:list	tree	admin	2023-05-22 09:33:47		\N	部门管理菜单
104	岗位管理	1	5	post	system/post/index		1	0	C	0	0	system:post:list	post	admin	2023-05-22 09:33:48		\N	岗位管理菜单
105	字典管理	1	6	dict	system/dict/index		1	0	C	0	0	system:dict:list	dict	admin	2023-05-22 09:33:49		\N	字典管理菜单
106	参数设置	1	7	config	system/config/index		1	0	C	0	0	system:config:list	edit	admin	2023-05-22 09:33:50		\N	参数设置菜单
107	通知公告	1	8	notice	system/notice/index		1	0	C	0	0	system:notice:list	message	admin	2023-05-22 09:33:51		\N	通知公告菜单
108	日志管理	1	9	log			1	0	M	0	0		log	admin	2023-05-22 09:33:51		\N	日志管理菜单
109	在线用户	2	1	online	monitor/online/index		1	0	C	0	0	monitor:online:list	online	admin	2023-05-22 09:33:52		\N	在线用户菜单
110	定时任务	2	2	job	monitor/job/index		1	0	C	0	0	monitor:job:list	job	admin	2023-05-22 09:33:53		\N	定时任务菜单
111	数据监控	2	3	druid	monitor/druid/index		1	0	C	0	0	monitor:druid:list	druid	admin	2023-05-22 09:33:53		\N	数据监控菜单
112	服务监控	2	4	server	monitor/server/index		1	0	C	0	0	monitor:server:list	server	admin	2023-05-22 09:33:54		\N	服务监控菜单
113	缓存监控	2	5	cache	monitor/cache/index		1	0	C	0	0	monitor:cache:list	redis	admin	2023-05-22 09:33:55		\N	缓存监控菜单
114	缓存列表	2	6	cacheList	monitor/cache/list		1	0	C	0	0	monitor:cache:list	redis-list	admin	2023-05-22 09:33:55		\N	缓存列表菜单
115	表单构建	3	1	build	tool/build/index		1	0	C	0	0	tool:build:list	build	admin	2023-05-22 09:33:56		\N	表单构建菜单
116	代码生成	3	2	gen	tool/gen/index		1	0	C	0	0	tool:gen:list	code	admin	2023-05-22 09:33:57		\N	代码生成菜单
117	系统接口	3	3	swagger	tool/swagger/index		1	0	C	0	0	tool:swagger:list	swagger	admin	2023-05-22 09:33:57		\N	系统接口菜单
500	操作日志	108	1	operlog	monitor/operlog/index		1	0	C	0	0	monitor:operlog:list	form	admin	2023-05-22 09:33:58		\N	操作日志菜单
501	登录日志	108	2	logininfor	monitor/logininfor/index		1	0	C	0	0	monitor:logininfor:list	logininfor	admin	2023-05-22 09:33:59		\N	登录日志菜单
1001	用户新增	100	2				1	0	F	0	0	system:user:add	#	admin	2023-05-22 09:34:00		\N	
1002	用户修改	100	3				1	0	F	0	0	system:user:edit	#	admin	2023-05-22 09:34:01		\N	
1003	用户删除	100	4				1	0	F	0	0	system:user:remove	#	admin	2023-05-22 09:34:02		\N	
1004	用户导出	100	5				1	0	F	0	0	system:user:export	#	admin	2023-05-22 09:34:02		\N	
1005	用户导入	100	6				1	0	F	0	0	system:user:import	#	admin	2023-05-22 09:34:03		\N	
1006	重置密码	100	7				1	0	F	0	0	system:user:resetPwd	#	admin	2023-05-22 09:34:04		\N	
1007	角色查询	101	1				1	0	F	0	0	system:role:query	#	admin	2023-05-22 09:34:04		\N	
1008	角色新增	101	2				1	0	F	0	0	system:role:add	#	admin	2023-05-22 09:34:05		\N	
1009	角色修改	101	3				1	0	F	0	0	system:role:edit	#	admin	2023-05-22 09:34:06		\N	
1010	角色删除	101	4				1	0	F	0	0	system:role:remove	#	admin	2023-05-22 09:34:06		\N	
1011	角色导出	101	5				1	0	F	0	0	system:role:export	#	admin	2023-05-22 09:34:07		\N	
1012	菜单查询	102	1				1	0	F	0	0	system:menu:query	#	admin	2023-05-22 09:34:08		\N	
1013	菜单新增	102	2				1	0	F	0	0	system:menu:add	#	admin	2023-05-22 09:34:08		\N	
1014	菜单修改	102	3				1	0	F	0	0	system:menu:edit	#	admin	2023-05-22 09:34:09		\N	
1015	菜单删除	102	4				1	0	F	0	0	system:menu:remove	#	admin	2023-05-22 09:34:10		\N	
1016	部门查询	103	1				1	0	F	0	0	system:dept:query	#	admin	2023-05-22 09:34:10		\N	
1017	部门新增	103	2				1	0	F	0	0	system:dept:add	#	admin	2023-05-22 09:34:11		\N	
1018	部门修改	103	3				1	0	F	0	0	system:dept:edit	#	admin	2023-05-22 09:34:12		\N	
1019	部门删除	103	4				1	0	F	0	0	system:dept:remove	#	admin	2023-05-22 09:34:12		\N	
1020	岗位查询	104	1				1	0	F	0	0	system:post:query	#	admin	2023-05-22 09:34:13		\N	
1021	岗位新增	104	2				1	0	F	0	0	system:post:add	#	admin	2023-05-22 09:34:14		\N	
1022	岗位修改	104	3				1	0	F	0	0	system:post:edit	#	admin	2023-05-22 09:34:14		\N	
1023	岗位删除	104	4				1	0	F	0	0	system:post:remove	#	admin	2023-05-22 09:34:15		\N	
1024	岗位导出	104	5				1	0	F	0	0	system:post:export	#	admin	2023-05-22 09:34:16		\N	
1025	字典查询	105	1	#			1	0	F	0	0	system:dict:query	#	admin	2023-05-22 09:34:16		\N	
1026	字典新增	105	2	#			1	0	F	0	0	system:dict:add	#	admin	2023-05-22 09:34:17		\N	
1027	字典修改	105	3	#			1	0	F	0	0	system:dict:edit	#	admin	2023-05-22 09:34:18		\N	
1028	字典删除	105	4	#			1	0	F	0	0	system:dict:remove	#	admin	2023-05-22 09:34:18		\N	
1029	字典导出	105	5	#			1	0	F	0	0	system:dict:export	#	admin	2023-05-22 09:34:19		\N	
1030	参数查询	106	1	#			1	0	F	0	0	system:config:query	#	admin	2023-05-22 09:34:20		\N	
1031	参数新增	106	2	#			1	0	F	0	0	system:config:add	#	admin	2023-05-22 09:34:20		\N	
1032	参数修改	106	3	#			1	0	F	0	0	system:config:edit	#	admin	2023-05-22 09:34:21		\N	
1033	参数删除	106	4	#			1	0	F	0	0	system:config:remove	#	admin	2023-05-22 09:34:22		\N	
1034	参数导出	106	5	#			1	0	F	0	0	system:config:export	#	admin	2023-05-22 09:34:23		\N	
1035	公告查询	107	1	#			1	0	F	0	0	system:notice:query	#	admin	2023-05-22 09:34:23		\N	
1036	公告新增	107	2	#			1	0	F	0	0	system:notice:add	#	admin	2023-05-22 09:34:24		\N	
1037	公告修改	107	3	#			1	0	F	0	0	system:notice:edit	#	admin	2023-05-22 09:34:25		\N	
1038	公告删除	107	4	#			1	0	F	0	0	system:notice:remove	#	admin	2023-05-22 09:34:25		\N	
1039	操作查询	500	1	#			1	0	F	0	0	monitor:operlog:query	#	admin	2023-05-22 09:34:26		\N	
1040	操作删除	500	2	#			1	0	F	0	0	monitor:operlog:remove	#	admin	2023-05-22 09:34:27		\N	
1041	日志导出	500	3	#			1	0	F	0	0	monitor:operlog:export	#	admin	2023-05-22 09:34:27		\N	
1042	登录查询	501	1	#			1	0	F	0	0	monitor:logininfor:query	#	admin	2023-05-22 09:34:28		\N	
1043	登录删除	501	2	#			1	0	F	0	0	monitor:logininfor:remove	#	admin	2023-05-22 09:34:29		\N	
1044	日志导出	501	3	#			1	0	F	0	0	monitor:logininfor:export	#	admin	2023-05-22 09:34:29		\N	
1045	账户解锁	501	4	#			1	0	F	0	0	monitor:logininfor:unlock	#	admin	2023-05-22 09:34:30		\N	
1046	在线查询	109	1	#			1	0	F	0	0	monitor:online:query	#	admin	2023-05-22 09:34:31		\N	
1047	批量强退	109	2	#			1	0	F	0	0	monitor:online:batchLogout	#	admin	2023-05-22 09:34:31		\N	
1048	单条强退	109	3	#			1	0	F	0	0	monitor:online:forceLogout	#	admin	2023-05-22 09:34:32		\N	
1049	任务查询	110	1	#			1	0	F	0	0	monitor:job:query	#	admin	2023-05-22 09:34:33		\N	
1050	任务新增	110	2	#			1	0	F	0	0	monitor:job:add	#	admin	2023-05-22 09:34:33		\N	
1051	任务修改	110	3	#			1	0	F	0	0	monitor:job:edit	#	admin	2023-05-22 09:34:34		\N	
1052	任务删除	110	4	#			1	0	F	0	0	monitor:job:remove	#	admin	2023-05-22 09:34:35		\N	
1053	状态修改	110	5	#			1	0	F	0	0	monitor:job:changeStatus	#	admin	2023-05-22 09:34:35		\N	
1054	任务导出	110	6	#			1	0	F	0	0	monitor:job:export	#	admin	2023-05-22 09:34:36		\N	
1055	生成查询	116	1	#			1	0	F	0	0	tool:gen:query	#	admin	2023-05-22 09:34:37		\N	
1056	生成修改	116	2	#			1	0	F	0	0	tool:gen:edit	#	admin	2023-05-22 09:34:37		\N	
1057	生成删除	116	3	#			1	0	F	0	0	tool:gen:remove	#	admin	2023-05-22 09:34:38		\N	
1058	导入代码	116	4	#			1	0	F	0	0	tool:gen:import	#	admin	2023-05-22 09:34:39		\N	
1059	预览代码	116	5	#			1	0	F	0	0	tool:gen:preview	#	admin	2023-05-22 09:34:39		\N	
1060	生成代码	116	6	#			1	0	F	0	0	tool:gen:code	#	admin	2023-05-22 09:34:40		\N	
1000	用户查询	100	2		\N	\N	1	0	F	0	0	system:user:query	#	admin	2023-05-22 09:33:59	admin	2023-12-21 20:15:03	
\.


--
-- Data for Name: sys_notice; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	温馨提醒：2018-07-01 若依新版本发布啦	2	2	0	admin	2023-05-22 09:36:27		\N	管理员
2	维护通知：2018-07-01 若依系统凌晨维护	1	1	0	admin	2023-05-22 09:36:28		\N	管理员
\.


--
-- Data for Name: sys_oper_log; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time, cost_time) FROM stdin;
168	操作日志	9	rykingbase.web.controller.monitor.SysOperlogController.clean()	DELETE	1	admin	研发部门	/monitor/operlog/clean	127.0.0.1	内网IP	{}	{"msg":"操作成功","code":200}	0	\N	2023-12-21 20:16:52	47
169	登录日志	9	rykingbase.web.controller.monitor.SysLogininforController.clean()	DELETE	1	admin	研发部门	/monitor/logininfor/clean	127.0.0.1	内网IP	{}	{"msg":"操作成功","code":200}	0	\N	2023-12-21 20:16:56	48
170	代码生成	2	rykingbase.generator.controller.GenController.editSave()	PUT	1	admin	研发部门	/tool/gen	127.0.0.1	内网IP	{"businessName":"certificate","className":"VehicleCertificate","columns":[{"capJavaField":"Id","columnId":14,"columnName":"id","columnType":"bigint(20)","createBy":"admin","createTime":"2023-05-23 09:38:13","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":true,"isIncrement":"1","isInsert":"1","isPk":"1","javaField":"id","javaType":"Long","list":false,"params":{},"pk":true,"query":false,"queryType":"EQ","required":false,"sort":1,"superColumn":false,"tableId":2,"updateBy":"","updateTime":"2023-05-24 03:13:29","usableColumn":false},{"capJavaField":"CreateBy","columnId":15,"columnName":"create_by","columnType":"bigint(20)","createBy":"admin","createTime":"2023-05-23 09:38:13","dictType":"","edit":false,"htmlType":"input","increment":false,"insert":true,"isIncrement":"0","isInsert":"1","isPk":"0","isRequired":"1","javaField":"createBy","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":true,"sort":2,"superColumn":true,"tableId":2,"updateBy":"","updateTime":"2023-05-24 03:13:29","usableColumn":false},{"capJavaField":"CreateTime","columnComment":"创建时间","columnId":16,"columnName":"create_time","columnType":"datetime","createBy":"admin","createTime":"2023-05-23 09:38:13","dictType":"","edit":false,"htmlType":"datetime","increment":false,"insert":true,"isIncrement":"0","isInsert":"1","isPk":"0","isRequired":"1","javaField":"createTime","javaType":"LocalDateTime","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":true,"sort":3,"superColumn":true,"tableId":2,"updateBy":"","updateTime":"2023-05-24 03:13:29","usableColumn":false},{"capJavaField":"UpdateBy","columnId":17,"columnName":"update_by","columnType":"bigint(20)","createBy":"admin","createTime":"2023-05-23 09:38:13","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isPk":"0","javaField":"updateBy","javaType":"Long","list":false,"params":{},"pk":false,"query	{"msg":"操作成功","code":200}	0	\N	2023-12-21 20:24:35	770
\.


--
-- Data for Name: sys_post; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	ceo	董事长	1	0	admin	2023-05-22 09:33:35		\N	
3	hr	人力资源	3	0	admin	2023-05-22 09:33:37		\N	
4	user	普通员工	4	0	admin	2023-05-22 09:33:37		\N	
2	se	项目经理	2	0	admin	2023-05-22 09:33:36	admin	2023-12-21 20:15:14	\N
\.


--
-- Data for Name: sys_role; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_role (role_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	超级管理员	admin	1	1	1	1	0	0	admin	2023-05-22 09:33:40		\N	超级管理员
2	普通角色	common	2	2	1	1	0	0	admin	2023-05-22 09:33:40	admin	2023-12-21 20:14:51	普通角色
\.


--
-- Data for Name: sys_role_dept; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_role_dept (role_id, dept_id) FROM stdin;
2	100
2	101
2	105
\.


--
-- Data for Name: sys_role_menu; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_role_menu (role_id, menu_id) FROM stdin;
2	1
2	100
2	1000
2	1001
2	1002
2	1003
2	1004
2	1005
2	1006
2	101
2	1007
2	1008
2	1009
2	1010
2	1011
2	102
2	1012
2	1013
2	1014
2	1015
2	103
2	1016
2	1017
2	1018
2	1019
2	104
2	1020
2	1021
2	1022
2	1023
2	1024
2	105
2	1025
2	1026
2	1027
2	1028
2	1029
2	106
2	1030
2	1031
2	1032
2	1033
2	1034
2	107
2	1035
2	1036
2	1037
2	1038
2	108
2	500
2	1039
2	1040
2	1041
2	501
2	1042
2	1043
2	1044
2	1045
2	2
2	109
2	1046
2	1047
2	1048
2	110
2	1049
2	1050
2	1051
2	1052
2	1053
2	1054
2	111
2	112
2	113
2	114
2	3
2	115
2	116
2	1055
2	1056
2	1057
2	1058
2	1059
2	1060
2	117
2	4
\.


--
-- Data for Name: sys_user; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	103	admin	若依	00	ry@163.com	15888888888	1		$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2	0	0	127.0.0.1	2023-12-21 19:46:05.555000	admin	2023-05-22 09:33:33		2023-12-21 19:46:07	管理员
100	100	tx	tx	00	\N	\N	0		$2a$10$tFEsI2x.EmleHK5hIjc31uiQtUCLrLqbiepHBb3poThpwu4FjCymO	0	0	127.0.0.1	2023-07-03 10:08:20	admin	2023-07-03 02:08:00	admin	2023-12-21 19:51:07	\N
2	105	ry	若依	00	ry@qq.com	15666666666	1		$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2	0	0	127.0.0.1	2023-05-22 09:33:33	admin	2023-05-22 09:33:33	admin	2023-12-21 20:13:56	测试员
\.


--
-- Data for Name: sys_user_post; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_user_post (user_id, post_id) FROM stdin;
1	1
2	2
\.


--
-- Data for Name: sys_user_role; Type: TABLE DATA; Schema: ry_vue; Owner: system
--

COPY ry_vue.sys_user_role (user_id, role_id) FROM stdin;
1	1
2	2
\.


--
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.gen_table_column_column_id_seq', 80, false);


--
-- Name: gen_table_table_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.gen_table_table_id_seq', 9, false);


--
-- Name: sys_config_config_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_config_config_id_seq', 6, false);


--
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_dept_dept_id_seq', 110, false);


--
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_dict_data_dict_code_seq', 30, false);


--
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_dict_type_dict_id_seq', 11, false);


--
-- Name: sys_job_job_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_job_job_id_seq', 4, false);


--
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_job_log_job_log_id_seq', 1, true);


--
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_logininfor_info_id_seq', 125, true);


--
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_menu_menu_id_seq', 1061, false);


--
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_notice_notice_id_seq', 4, false);


--
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_oper_log_oper_id_seq', 170, true);


--
-- Name: sys_post_post_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_post_post_id_seq', 5, false);


--
-- Name: sys_role_role_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_role_role_id_seq', 3, false);


--
-- Name: sys_user_user_id_seq; Type: SEQUENCE SET; Schema: ry_vue; Owner: system
--

SELECT pg_catalog.setval('ry_vue.sys_user_user_id_seq', 101, false);


--
-- Name: QRTZ_SIMPROP_TRIGGERS PRIMARY_1AFB6ACD; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_SIMPROP_TRIGGERS"
    ADD CONSTRAINT "PRIMARY_1AFB6ACD" PRIMARY KEY (sched_name, trigger_group, trigger_name);


--
-- Name: QRTZ_JOB_DETAILS PRIMARY_20ACD13B; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_JOB_DETAILS"
    ADD CONSTRAINT "PRIMARY_20ACD13B" PRIMARY KEY (job_group, job_name, sched_name);


--
-- Name: QRTZ_SCHEDULER_STATE PRIMARY_261690D2; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_SCHEDULER_STATE"
    ADD CONSTRAINT "PRIMARY_261690D2" PRIMARY KEY (instance_name, sched_name);


--
-- Name: sys_config PRIMARY_3BDA5CE4; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_config
    ADD CONSTRAINT "PRIMARY_3BDA5CE4" PRIMARY KEY (config_id);


--
-- Name: sys_user_post PRIMARY_43097AA8; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_user_post
    ADD CONSTRAINT "PRIMARY_43097AA8" PRIMARY KEY (post_id, user_id);


--
-- Name: QRTZ_TRIGGERS PRIMARY_528D64F2; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_TRIGGERS"
    ADD CONSTRAINT "PRIMARY_528D64F2" PRIMARY KEY (sched_name, trigger_group, trigger_name);


--
-- Name: sys_user_role PRIMARY_5CF660FC; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_user_role
    ADD CONSTRAINT "PRIMARY_5CF660FC" PRIMARY KEY (role_id, user_id);


--
-- Name: QRTZ_PAUSED_TRIGGER_GRPS PRIMARY_629BC35A; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_PAUSED_TRIGGER_GRPS"
    ADD CONSTRAINT "PRIMARY_629BC35A" PRIMARY KEY (sched_name, trigger_group);


--
-- Name: sys_job_log PRIMARY_65F80228; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_job_log
    ADD CONSTRAINT "PRIMARY_65F80228" PRIMARY KEY (job_log_id);


--
-- Name: sys_role_menu PRIMARY_6B9F418A; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_role_menu
    ADD CONSTRAINT "PRIMARY_6B9F418A" PRIMARY KEY (menu_id, role_id);


--
-- Name: sys_user PRIMARY_6E2FB552; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_user
    ADD CONSTRAINT "PRIMARY_6E2FB552" PRIMARY KEY (user_id);


--
-- Name: sys_oper_log PRIMARY_7921EFE7; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_oper_log
    ADD CONSTRAINT "PRIMARY_7921EFE7" PRIMARY KEY (oper_id);


--
-- Name: QRTZ_FIRED_TRIGGERS PRIMARY_7D6B8866; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_FIRED_TRIGGERS"
    ADD CONSTRAINT "PRIMARY_7D6B8866" PRIMARY KEY (entry_id, sched_name);


--
-- Name: sys_role PRIMARY_7EFFF0FC; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_role
    ADD CONSTRAINT "PRIMARY_7EFFF0FC" PRIMARY KEY (role_id);


--
-- Name: sys_dept PRIMARY_817FF65E; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dept
    ADD CONSTRAINT "PRIMARY_817FF65E" PRIMARY KEY (dept_id);


--
-- Name: QRTZ_CRON_TRIGGERS PRIMARY_86CCB771; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_CRON_TRIGGERS"
    ADD CONSTRAINT "PRIMARY_86CCB771" PRIMARY KEY (sched_name, trigger_group, trigger_name);


--
-- Name: sys_job PRIMARY_91256962; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_job
    ADD CONSTRAINT "PRIMARY_91256962" PRIMARY KEY (job_group, job_id, job_name);


--
-- Name: QRTZ_BLOB_TRIGGERS PRIMARY_958B1400; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_BLOB_TRIGGERS"
    ADD CONSTRAINT "PRIMARY_958B1400" PRIMARY KEY (sched_name, trigger_group, trigger_name);


--
-- Name: QRTZ_LOCKS PRIMARY_984FDBE3; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_LOCKS"
    ADD CONSTRAINT "PRIMARY_984FDBE3" PRIMARY KEY (lock_name, sched_name);


--
-- Name: sys_logininfor PRIMARY_A4D1B11F; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_logininfor
    ADD CONSTRAINT "PRIMARY_A4D1B11F" PRIMARY KEY (info_id);


--
-- Name: sys_dict_type PRIMARY_A6E4B4D3; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dict_type
    ADD CONSTRAINT "PRIMARY_A6E4B4D3" PRIMARY KEY (dict_id);


--
-- Name: gen_table_column PRIMARY_BD14958E; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.gen_table_column
    ADD CONSTRAINT "PRIMARY_BD14958E" PRIMARY KEY (column_id);


--
-- Name: QRTZ_CALENDARS PRIMARY_C30EDA83; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_CALENDARS"
    ADD CONSTRAINT "PRIMARY_C30EDA83" PRIMARY KEY (calendar_name, sched_name);


--
-- Name: sys_role_dept PRIMARY_D4CC35BE; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_role_dept
    ADD CONSTRAINT "PRIMARY_D4CC35BE" PRIMARY KEY (dept_id, role_id);


--
-- Name: sys_dict_data PRIMARY_DFD26535; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dict_data
    ADD CONSTRAINT "PRIMARY_DFD26535" PRIMARY KEY (dict_code);


--
-- Name: gen_table PRIMARY_E2A7B70B; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.gen_table
    ADD CONSTRAINT "PRIMARY_E2A7B70B" PRIMARY KEY (table_id);


--
-- Name: sys_notice PRIMARY_EFB5DD38; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_notice
    ADD CONSTRAINT "PRIMARY_EFB5DD38" PRIMARY KEY (notice_id);


--
-- Name: QRTZ_SIMPLE_TRIGGERS PRIMARY_F0406695; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_SIMPLE_TRIGGERS"
    ADD CONSTRAINT "PRIMARY_F0406695" PRIMARY KEY (sched_name, trigger_group, trigger_name);


--
-- Name: sys_menu PRIMARY_F5518E2A; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_menu
    ADD CONSTRAINT "PRIMARY_F5518E2A" PRIMARY KEY (menu_id);


--
-- Name: sys_post PRIMARY_F66D76A8; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_post
    ADD CONSTRAINT "PRIMARY_F66D76A8" PRIMARY KEY (post_id);


--
-- Name: sys_dict_type dict_type_2399F8D6; Type: CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue.sys_dict_type
    ADD CONSTRAINT "dict_type_2399F8D6" UNIQUE (dict_type);


--
-- Name: sched_name_E4C6234; Type: INDEX; Schema: ry_vue; Owner: system
--

CREATE INDEX sched_name_E4C6234 ON ry_vue.QRTZ_TRIGGERS USING btree (sched_name, job_name, job_group);


--
-- Name: QRTZ_BLOB_TRIGGERS QRTZ_BLOB_TRIGGERS_ibfk_1_235FB660; Type: FK CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_BLOB_TRIGGERS"
    ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_ibfk_1_235FB660" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ry_vue.QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: QRTZ_CRON_TRIGGERS QRTZ_CRON_TRIGGERS_ibfk_1_A0076A00; Type: FK CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_CRON_TRIGGERS"
    ADD CONSTRAINT "QRTZ_CRON_TRIGGERS_ibfk_1_A0076A00" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ry_vue.QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: QRTZ_SIMPLE_TRIGGERS QRTZ_SIMPLE_TRIGGERS_ibfk_1_823DECC0; Type: FK CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_SIMPLE_TRIGGERS"
    ADD CONSTRAINT "QRTZ_SIMPLE_TRIGGERS_ibfk_1_823DECC0" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ry_vue.QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: QRTZ_SIMPROP_TRIGGERS QRTZ_SIMPROP_TRIGGERS_ibfk_1_E1D87F92; Type: FK CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_SIMPROP_TRIGGERS"
    ADD CONSTRAINT "QRTZ_SIMPROP_TRIGGERS_ibfk_1_E1D87F92" FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ry_vue.QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: QRTZ_TRIGGERS QRTZ_TRIGGERS_ibfk_1_608ABE8; Type: FK CONSTRAINT; Schema: ry_vue; Owner: system
--

ALTER TABLE ONLY ry_vue."QRTZ_TRIGGERS"
    ADD CONSTRAINT "QRTZ_TRIGGERS_ibfk_1_608ABE8" FOREIGN KEY (sched_name, job_name, job_group) REFERENCES ry_vue.QRTZ_JOB_DETAILS(sched_name, job_name, job_group) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: SCHEMA sys; Type: ACL; Schema: -; Owner: system
--

GRANT USAGE ON SCHEMA sys TO PUBLIC;


--
-- Name: SCHEMA sys_catalog; Type: ACL; Schema: -; Owner: system
--

GRANT USAGE ON SCHEMA sys_catalog TO PUBLIC;


--
-- Name: FUNCTION qps(); Type: ACL; Schema: pg_catalog; Owner: system
--

REVOKE ALL ON FUNCTION pg_catalog.qps() FROM PUBLIC;
GRANT ALL ON FUNCTION pg_catalog.qps() TO pg_monitor;


--
-- Name: FUNCTION tps(); Type: ACL; Schema: pg_catalog; Owner: system
--

REVOKE ALL ON FUNCTION pg_catalog.tps() FROM PUBLIC;
GRANT ALL ON FUNCTION pg_catalog.tps() TO pg_monitor;


--
-- Name: FUNCTION sys_config(name OUT text, setting OUT text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_config(name OUT text, setting OUT text) FROM PUBLIC;


--
-- Name: FUNCTION sys_create_restore_point(text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_create_restore_point(text) FROM PUBLIC;


--
-- Name: FUNCTION sys_current_logfile(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_current_logfile() FROM PUBLIC;


--
-- Name: FUNCTION sys_current_logfile(text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_current_logfile(text) FROM PUBLIC;


--
-- Name: FUNCTION sys_hba_file_rules(line_number OUT integer, type OUT text, database OUT text[], user_name OUT text[], address OUT text, netmask OUT text, auth_method OUT text, options OUT text[], error OUT text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_hba_file_rules(line_number OUT integer, type OUT text, database OUT text[], user_name OUT text[], address OUT text, netmask OUT text, auth_method OUT text, options OUT text[], error OUT text) FROM PUBLIC;


--
-- Name: FUNCTION sys_ls_archive_statusdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_archive_statusdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) FROM PUBLIC;
GRANT ALL ON FUNCTION sys_catalog.sys_ls_archive_statusdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) TO pg_monitor;


--
-- Name: FUNCTION sys_ls_dir(text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_dir(text) FROM PUBLIC;


--
-- Name: FUNCTION sys_ls_dir(text, boolean, boolean); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_dir(text, boolean, boolean) FROM PUBLIC;


--
-- Name: FUNCTION sys_ls_logdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_logdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) FROM PUBLIC;
GRANT ALL ON FUNCTION sys_catalog.sys_ls_logdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) TO pg_monitor;


--
-- Name: FUNCTION sys_ls_tmpdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_tmpdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) FROM PUBLIC;
GRANT ALL ON FUNCTION sys_catalog.sys_ls_tmpdir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) TO pg_monitor;


--
-- Name: FUNCTION sys_ls_tmpdir(tablespace oid, name OUT text, size OUT bigint, modification OUT timestamp with time zone); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_tmpdir(tablespace oid, name OUT text, size OUT bigint, modification OUT timestamp with time zone) FROM PUBLIC;
GRANT ALL ON FUNCTION sys_catalog.sys_ls_tmpdir(tablespace oid, name OUT text, size OUT bigint, modification OUT timestamp with time zone) TO pg_monitor;


--
-- Name: FUNCTION sys_ls_waldir(name OUT text, size OUT bigint, modification OUT timestamp with time zone); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_ls_waldir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) FROM PUBLIC;
GRANT ALL ON FUNCTION sys_catalog.sys_ls_waldir(name OUT text, size OUT bigint, modification OUT timestamp with time zone) TO pg_monitor;


--
-- Name: FUNCTION sys_promote(wait boolean, wait_seconds integer); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_promote(wait boolean, wait_seconds integer) FROM PUBLIC;


--
-- Name: FUNCTION sys_read_binary_file(text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_read_binary_file(text) FROM PUBLIC;


--
-- Name: FUNCTION sys_read_binary_file(text, bigint, bigint); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_read_binary_file(text, bigint, bigint) FROM PUBLIC;


--
-- Name: FUNCTION sys_read_binary_file(text, bigint, bigint, boolean); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_read_binary_file(text, bigint, bigint, boolean) FROM PUBLIC;


--
-- Name: FUNCTION sys_read_file(text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_read_file(text) FROM PUBLIC;


--
-- Name: FUNCTION sys_read_file(text, bigint, bigint); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_read_file(text, bigint, bigint) FROM PUBLIC;


--
-- Name: FUNCTION sys_read_file(text, bigint, bigint, boolean); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_read_file(text, bigint, bigint, boolean) FROM PUBLIC;


--
-- Name: FUNCTION sys_rotate_logfile(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_rotate_logfile() FROM PUBLIC;


--
-- Name: FUNCTION sys_show_all_file_settings(sourcefile OUT text, sourceline OUT integer, seqno OUT integer, name OUT text, setting OUT text, applied OUT boolean, error OUT text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_show_all_file_settings(sourcefile OUT text, sourceline OUT integer, seqno OUT integer, name OUT text, setting OUT text, applied OUT boolean, error OUT text) FROM PUBLIC;


--
-- Name: FUNCTION sys_start_backup(label text, fast boolean, exclusive boolean); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_start_backup(label text, fast boolean, exclusive boolean) FROM PUBLIC;


--
-- Name: FUNCTION sys_stat_file(filename text, size OUT bigint, access OUT timestamp with time zone, modification OUT timestamp with time zone, change OUT timestamp with time zone, creation OUT timestamp with time zone, isdir OUT boolean); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stat_file(filename text, size OUT bigint, access OUT timestamp with time zone, modification OUT timestamp with time zone, change OUT timestamp with time zone, creation OUT timestamp with time zone, isdir OUT boolean) FROM PUBLIC;


--
-- Name: FUNCTION sys_stat_file(filename text, missing_ok boolean, size OUT bigint, access OUT timestamp with time zone, modification OUT timestamp with time zone, change OUT timestamp with time zone, creation OUT timestamp with time zone, isdir OUT boolean); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stat_file(filename text, missing_ok boolean, size OUT bigint, access OUT timestamp with time zone, modification OUT timestamp with time zone, change OUT timestamp with time zone, creation OUT timestamp with time zone, isdir OUT boolean) FROM PUBLIC;


--
-- Name: FUNCTION sys_stat_reset(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stat_reset() FROM PUBLIC;


--
-- Name: FUNCTION sys_stat_reset_shared(text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stat_reset_shared(text) FROM PUBLIC;


--
-- Name: FUNCTION sys_stat_reset_single_function_counters(oid); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stat_reset_single_function_counters(oid) FROM PUBLIC;


--
-- Name: FUNCTION sys_stat_reset_single_table_counters(oid); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stat_reset_single_table_counters(oid) FROM PUBLIC;


--
-- Name: FUNCTION sys_stop_backup(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stop_backup() FROM PUBLIC;


--
-- Name: FUNCTION sys_stop_backup(exclusive boolean, wait_for_archive boolean, lsn OUT pg_lsn, labelfile OUT text, spcmapfile OUT text); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_stop_backup(exclusive boolean, wait_for_archive boolean, lsn OUT pg_lsn, labelfile OUT text, spcmapfile OUT text) FROM PUBLIC;


--
-- Name: FUNCTION sys_switch_wal(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_switch_wal() FROM PUBLIC;


--
-- Name: FUNCTION sys_wal_replay_pause(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_wal_replay_pause() FROM PUBLIC;


--
-- Name: FUNCTION sys_wal_replay_resume(); Type: ACL; Schema: sys_catalog; Owner: system
--

REVOKE ALL ON FUNCTION sys_catalog.sys_wal_replay_resume() FROM PUBLIC;


--
-- Name: TABLE all_arguments; Type: ACL; Schema: pg_catalog; Owner: system
--

GRANT SELECT ON TABLE pg_catalog.all_arguments TO PUBLIC;


--
-- Name: TABLE pg_triggers; Type: ACL; Schema: pg_catalog; Owner: system
--

GRANT SELECT ON TABLE pg_catalog.pg_triggers TO PUBLIC;


--
-- Name: TABLE user_arguments; Type: ACL; Schema: pg_catalog; Owner: system
--

GRANT SELECT ON TABLE pg_catalog.user_arguments TO PUBLIC;


--
-- Name: TABLE "ALL_CONSTRAINTS"; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys."ALL_CONSTRAINTS" TO PUBLIC;


--
-- Name: TABLE "ALL_INDEXES"; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys."ALL_INDEXES" TO PUBLIC;


--
-- Name: TABLE "USER_INDEXES"; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys."USER_INDEXES" TO PUBLIC;


--
-- Name: TABLE all_all_tables; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_all_tables TO PUBLIC;


--
-- Name: TABLE all_col_comments; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_col_comments TO PUBLIC;


--
-- Name: TABLE all_col_privs; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_col_privs TO PUBLIC;


--
-- Name: TABLE all_cons_columns; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_cons_columns TO PUBLIC;


--
-- Name: TABLE all_db_links; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_db_links TO PUBLIC;


--
-- Name: TABLE all_directories; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_directories TO PUBLIC;


--
-- Name: TABLE all_ind_columns; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_ind_columns TO PUBLIC;


--
-- Name: TABLE all_objects; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_objects TO PUBLIC;


--
-- Name: TABLE all_part_tables; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_part_tables TO PUBLIC;


--
-- Name: TABLE all_sequences; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_sequences TO PUBLIC;


--
-- Name: TABLE all_source; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_source TO PUBLIC;


--
-- Name: TABLE all_synonyms; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_synonyms TO PUBLIC;


--
-- Name: TABLE all_tab_cols; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_tab_cols TO PUBLIC;


--
-- Name: TABLE all_tab_columns; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_tab_columns TO PUBLIC;


--
-- Name: TABLE all_tab_comments; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_tab_comments TO PUBLIC;


--
-- Name: TABLE all_tab_partitions; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_tab_partitions TO PUBLIC;


--
-- Name: TABLE all_tab_privs; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_tab_privs TO PUBLIC;


--
-- Name: TABLE all_tables; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_tables TO PUBLIC;


--
-- Name: TABLE all_trigger_cols; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_trigger_cols TO PUBLIC;


--
-- Name: TABLE all_triggers; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_triggers TO PUBLIC;


--
-- Name: TABLE all_types; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_types TO PUBLIC;


--
-- Name: TABLE all_users; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_users TO PUBLIC;


--
-- Name: TABLE all_views; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.all_views TO PUBLIC;


--
-- Name: TABLE dual; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.dual TO PUBLIC;


--
-- Name: TABLE sys_session; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.sys_session TO PUBLIC;


--
-- Name: TABLE user_all_tables; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_all_tables TO PUBLIC;


--
-- Name: TABLE user_col_comments; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_col_comments TO PUBLIC;


--
-- Name: TABLE user_col_privs; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_col_privs TO PUBLIC;


--
-- Name: TABLE user_cons_columns; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_cons_columns TO PUBLIC;


--
-- Name: TABLE user_constraints; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_constraints TO PUBLIC;


--
-- Name: TABLE user_db_links; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_db_links TO PUBLIC;


--
-- Name: TABLE user_directories; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_directories TO PUBLIC;


--
-- Name: TABLE user_ind_columns; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_ind_columns TO PUBLIC;


--
-- Name: TABLE user_objects; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_objects TO PUBLIC;


--
-- Name: TABLE user_part_tables; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_part_tables TO PUBLIC;


--
-- Name: TABLE user_role_privs; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_role_privs TO PUBLIC;


--
-- Name: TABLE user_sequences; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_sequences TO PUBLIC;


--
-- Name: TABLE user_source; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_source TO PUBLIC;


--
-- Name: TABLE user_synonyms; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_synonyms TO PUBLIC;


--
-- Name: TABLE user_tab_cols; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tab_cols TO PUBLIC;


--
-- Name: TABLE user_tab_columns; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tab_columns TO PUBLIC;


--
-- Name: TABLE user_tab_comments; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tab_comments TO PUBLIC;


--
-- Name: TABLE user_tab_partitions; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tab_partitions TO PUBLIC;


--
-- Name: TABLE user_tab_privs; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tab_privs TO PUBLIC;


--
-- Name: TABLE user_table_cols; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_table_cols TO PUBLIC;


--
-- Name: TABLE user_tables; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tables TO PUBLIC;


--
-- Name: TABLE user_tablespace; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tablespace TO PUBLIC;


--
-- Name: TABLE user_tablespaces; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_tablespaces TO PUBLIC;


--
-- Name: TABLE user_trigger_cols; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_trigger_cols TO PUBLIC;


--
-- Name: TABLE user_triggers; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_triggers TO PUBLIC;


--
-- Name: TABLE user_types; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_types TO PUBLIC;


--
-- Name: TABLE user_users; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_users TO PUBLIC;


--
-- Name: TABLE user_views; Type: ACL; Schema: sys; Owner: system
--

GRANT SELECT ON TABLE sys.user_views TO PUBLIC;


--
-- Name: TABLE sys_aggregate; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_aggregate TO PUBLIC;


--
-- Name: TABLE sys_am; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_am TO PUBLIC;


--
-- Name: TABLE sys_amop; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_amop TO PUBLIC;


--
-- Name: TABLE sys_amproc; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_amproc TO PUBLIC;


--
-- Name: TABLE sys_attrdef; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_attrdef TO PUBLIC;


--
-- Name: TABLE sys_attribute; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_attribute TO PUBLIC;


--
-- Name: TABLE sys_auth_members; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_auth_members TO PUBLIC;


--
-- Name: TABLE sys_available_extension_versions; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_available_extension_versions TO PUBLIC;


--
-- Name: TABLE sys_available_extensions; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_available_extensions TO PUBLIC;


--
-- Name: TABLE sys_cast; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_cast TO PUBLIC;


--
-- Name: TABLE sys_class; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_class TO PUBLIC;


--
-- Name: TABLE sys_collation; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_collation TO PUBLIC;


--
-- Name: TABLE sys_constraint; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_constraint TO PUBLIC;


--
-- Name: TABLE sys_constraint_status; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_constraint_status TO PUBLIC;


--
-- Name: TABLE sys_context; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_context TO PUBLIC;


--
-- Name: TABLE sys_conversion; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_conversion TO PUBLIC;


--
-- Name: TABLE sys_cursors; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_cursors TO PUBLIC;


--
-- Name: TABLE sys_database; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_database TO PUBLIC;


--
-- Name: TABLE sys_db_role_setting; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_db_role_setting TO PUBLIC;


--
-- Name: TABLE sys_default_acl; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_default_acl TO PUBLIC;


--
-- Name: TABLE sys_depend; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_depend TO PUBLIC;


--
-- Name: TABLE sys_description; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_description TO PUBLIC;


--
-- Name: TABLE sys_enum; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_enum TO PUBLIC;


--
-- Name: TABLE sys_event_trigger; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_event_trigger TO PUBLIC;


--
-- Name: TABLE sys_extension; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_extension TO PUBLIC;


--
-- Name: TABLE sys_foreign_data_wrapper; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_foreign_data_wrapper TO PUBLIC;


--
-- Name: TABLE sys_foreign_server; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_foreign_server TO PUBLIC;


--
-- Name: TABLE sys_foreign_table; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_foreign_table TO PUBLIC;


--
-- Name: TABLE sys_group; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_group TO PUBLIC;


--
-- Name: TABLE sys_index; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_index TO PUBLIC;


--
-- Name: TABLE sys_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_indexes TO PUBLIC;


--
-- Name: TABLE sys_inherits; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_inherits TO PUBLIC;


--
-- Name: TABLE sys_init_privs; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_init_privs TO PUBLIC;


--
-- Name: TABLE sys_language; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_language TO PUBLIC;


--
-- Name: TABLE sys_largeobject_metadata; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_largeobject_metadata TO PUBLIC;


--
-- Name: TABLE sys_locks; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_locks TO PUBLIC;


--
-- Name: TABLE sys_matviews; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_matviews TO PUBLIC;


--
-- Name: TABLE sys_namespace; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_namespace TO PUBLIC;


--
-- Name: TABLE sys_objects; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_objects TO PUBLIC;


--
-- Name: TABLE sys_opclass; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_opclass TO PUBLIC;


--
-- Name: TABLE sys_operator; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_operator TO PUBLIC;


--
-- Name: TABLE sys_opfamily; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_opfamily TO PUBLIC;


--
-- Name: TABLE sys_partitioned_table; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_partitioned_table TO PUBLIC;


--
-- Name: TABLE sys_pltemplate; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_pltemplate TO PUBLIC;


--
-- Name: TABLE sys_policies; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_policies TO PUBLIC;


--
-- Name: TABLE sys_policy; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_policy TO PUBLIC;


--
-- Name: TABLE sys_prepared_statements; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_prepared_statements TO PUBLIC;


--
-- Name: TABLE sys_prepared_xacts; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_prepared_xacts TO PUBLIC;


--
-- Name: TABLE sys_proc; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_proc TO PUBLIC;


--
-- Name: TABLE sys_publication; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_publication TO PUBLIC;


--
-- Name: TABLE sys_publication_rel; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_publication_rel TO PUBLIC;


--
-- Name: TABLE sys_publication_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_publication_tables TO PUBLIC;


--
-- Name: TABLE sys_range; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_range TO PUBLIC;


--
-- Name: TABLE sys_replication_origin; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_replication_origin TO PUBLIC;


--
-- Name: TABLE sys_replication_slots; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_replication_slots TO PUBLIC;


--
-- Name: TABLE sys_rewrite; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_rewrite TO PUBLIC;


--
-- Name: TABLE sys_roles; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_roles TO PUBLIC;


--
-- Name: TABLE sys_rules; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_rules TO PUBLIC;


--
-- Name: TABLE sys_seclabel; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_seclabel TO PUBLIC;


--
-- Name: TABLE sys_seclabels; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_seclabels TO PUBLIC;


--
-- Name: TABLE sys_sequence; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_sequence TO PUBLIC;


--
-- Name: TABLE sys_sequences; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_sequences TO PUBLIC;


--
-- Name: TABLE sys_settings; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_settings TO PUBLIC;


--
-- Name: TABLE sys_shdepend; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_shdepend TO PUBLIC;


--
-- Name: TABLE sys_shdescription; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_shdescription TO PUBLIC;


--
-- Name: TABLE sys_shseclabel; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_shseclabel TO PUBLIC;


--
-- Name: TABLE sys_tablespace; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_tablespace TO PUBLIC;


--
-- Name: TABLE sys_space_quota; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_space_quota TO PUBLIC;


--
-- Name: TABLE sys_stat_activity; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_activity TO PUBLIC;


--
-- Name: TABLE sys_stat_all_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_all_indexes TO PUBLIC;


--
-- Name: TABLE sys_stat_all_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_all_tables TO PUBLIC;


--
-- Name: TABLE sys_stat_archiver; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_archiver TO PUBLIC;


--
-- Name: TABLE sys_stat_bgwriter; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_bgwriter TO PUBLIC;


--
-- Name: TABLE sys_stat_database; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_database TO PUBLIC;


--
-- Name: TABLE sys_stat_database_conflicts; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_database_conflicts TO PUBLIC;


--
-- Name: TABLE sys_stat_gssapi; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_gssapi TO PUBLIC;


--
-- Name: TABLE sys_stat_instevent; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_instevent TO PUBLIC;


--
-- Name: TABLE sys_stat_instio; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_instio TO PUBLIC;


--
-- Name: TABLE sys_stat_instlock; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_instlock TO PUBLIC;


--
-- Name: TABLE sys_stat_msgaccum; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_msgaccum TO PUBLIC;


--
-- Name: TABLE sys_stat_progress_cluster; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_progress_cluster TO PUBLIC;


--
-- Name: TABLE sys_stat_progress_create_index; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_progress_create_index TO PUBLIC;


--
-- Name: TABLE sys_stat_progress_vacuum; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_progress_vacuum TO PUBLIC;


--
-- Name: TABLE sys_stat_replication; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_replication TO PUBLIC;


--
-- Name: TABLE sys_stat_shmem; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_shmem TO PUBLIC;


--
-- Name: TABLE sys_stat_sqlio; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_sqlio TO PUBLIC;


--
-- Name: TABLE sys_stat_sqltime; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_sqltime TO PUBLIC;


--
-- Name: TABLE sys_stat_sqlwait; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_sqlwait TO PUBLIC;


--
-- Name: TABLE sys_stat_ssl; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_ssl TO PUBLIC;


--
-- Name: TABLE sys_stat_subscription; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_subscription TO PUBLIC;


--
-- Name: TABLE sys_stat_sys_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_sys_indexes TO PUBLIC;


--
-- Name: TABLE sys_stat_sys_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_sys_tables TO PUBLIC;


--
-- Name: TABLE sys_stat_user_functions; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_user_functions TO PUBLIC;


--
-- Name: TABLE sys_stat_user_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_user_indexes TO PUBLIC;


--
-- Name: TABLE sys_stat_user_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_user_tables TO PUBLIC;


--
-- Name: TABLE sys_stat_waitaccum; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_waitaccum TO PUBLIC;


--
-- Name: TABLE sys_stat_wal_receiver; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_wal_receiver TO PUBLIC;


--
-- Name: TABLE sys_stat_xact_all_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_xact_all_tables TO PUBLIC;


--
-- Name: TABLE sys_stat_xact_sys_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_xact_sys_tables TO PUBLIC;


--
-- Name: TABLE sys_stat_xact_user_functions; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_xact_user_functions TO PUBLIC;


--
-- Name: TABLE sys_stat_xact_user_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stat_xact_user_tables TO PUBLIC;


--
-- Name: TABLE sys_statio_all_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_all_indexes TO PUBLIC;


--
-- Name: TABLE sys_statio_all_sequences; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_all_sequences TO PUBLIC;


--
-- Name: TABLE sys_statio_all_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_all_tables TO PUBLIC;


--
-- Name: TABLE sys_statio_sys_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_sys_indexes TO PUBLIC;


--
-- Name: TABLE sys_statio_sys_sequences; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_sys_sequences TO PUBLIC;


--
-- Name: TABLE sys_statio_sys_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_sys_tables TO PUBLIC;


--
-- Name: TABLE sys_statio_user_indexes; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_user_indexes TO PUBLIC;


--
-- Name: TABLE sys_statio_user_sequences; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_user_sequences TO PUBLIC;


--
-- Name: TABLE sys_statio_user_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statio_user_tables TO PUBLIC;


--
-- Name: TABLE sys_statistic_ext; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_statistic_ext TO PUBLIC;


--
-- Name: TABLE sys_stats; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stats TO PUBLIC;


--
-- Name: TABLE sys_stats_ext; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_stats_ext TO PUBLIC;


--
-- Name: TABLE sys_subpartition_table; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_subpartition_table TO PUBLIC;


--
-- Name: TABLE sys_subscription_rel; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_subscription_rel TO PUBLIC;


--
-- Name: TABLE sys_tables; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_tables TO PUBLIC;


--
-- Name: TABLE sys_timezone_abbrevs; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_timezone_abbrevs TO PUBLIC;


--
-- Name: TABLE sys_timezone_names; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_timezone_names TO PUBLIC;


--
-- Name: TABLE sys_transform; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_transform TO PUBLIC;


--
-- Name: TABLE sys_trigger; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_trigger TO PUBLIC;


--
-- Name: TABLE sys_triggers; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_triggers TO PUBLIC;


--
-- Name: TABLE sys_ts_config; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_ts_config TO PUBLIC;


--
-- Name: TABLE sys_ts_config_map; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_ts_config_map TO PUBLIC;


--
-- Name: TABLE sys_ts_dict; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_ts_dict TO PUBLIC;


--
-- Name: TABLE sys_ts_parser; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_ts_parser TO PUBLIC;


--
-- Name: TABLE sys_ts_template; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_ts_template TO PUBLIC;


--
-- Name: TABLE sys_type; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_type TO PUBLIC;


--
-- Name: TABLE sys_user; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_user TO PUBLIC;


--
-- Name: TABLE sys_user_mappings; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_user_mappings TO PUBLIC;


--
-- Name: TABLE sys_views; Type: ACL; Schema: sys_catalog; Owner: system
--

GRANT SELECT ON TABLE sys_catalog.sys_views TO PUBLIC;


--
-- Kingbase database dump complete
--

